Excel Help

[Closed]
Report
-
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
-
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???

1 reply

Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
182
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!