Previous Topic Next Topic

Excel Help

Closed
kcinruoy - 12 Nov 2009 à 11:04
sharpman Posts 1021 Registration date Saturday 23 May 2009 Status Contributor Last seen 20 October 2010 - 15 Nov 2009 à 14:39
Hello,

I need to copy a formula using data from another column, but I need to do this for the whole sheet:

Let's say my formula is --> ='Sheet1 (2)'!$M$51+'Sheet1 (2)'!$M$52+'Sheet1 (2)'!$M$53, and the entire sheet is in this format...

But, I want it to read --> ='Sheet1 (2)'!$N$51+'Sheet1 (2)'!$N$52+'Sheet1 (2)'!$N$53

how do i reference another column, but maintain the formula throughout the entire sheet???
Related:

1 response

Réponse 1 / 1
sharpman Posts 1021 Registration date Saturday 23 May 2009 Status Contributor Last seen 20 October 2010 183
15 Nov 2009 à 14:39
you can do a search replace.
using the formula that you wish to replace as your search criteria and the formula that you wish to be replaced with as your replacement criteria.

ie search $M$ and replace it with $N$

hope this is what you are looking for.

Similar discussions

Convert YouTube software
Nadia_7160 -
ankit213506 -

2 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses