Copying formulas and changing

[andrewb90]

I am hoping this is actually pretty easy, but how do I copy all of the formulas in Column D5:60 and paste them in column E5:60 without changing the cell reference but being able to change the sheet reference. (This may be two different things)
ex. in D5 the formula is = Mon!G12 I want to put that formula into the next column H5 but I want to make it Inst!G12

 

[Robert Mika]

You can use Find and Replace tool to change only the part of the formula you need by highlighting cells which you need.

 

[jasonb75]

To stop the column changing in the cell reference when you copy use

=Mon!$G12

 

[andrewb90]

Awesome! Thanks!