Excel Help

Closed
kcinruoy - Nov 12, 2009 at 11:04 AM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Nov 15, 2009 at 02:39 PM
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

sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 183
Nov 15, 2009 at 02:39 PM
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.
0