How do I copy a bunch of formulas, but change the worksheet they refer to?

[bovinda]

I need to copy a column of formulas from one column to another, but I want to change the worksheet to which they refer. Is there any way to do this without laboriously editing each formula to refer to the correct sheet?

For example, I have column F, which displays values from a number of different places in a worksheet called "Jan", so it is filled with formulas like "=Jan!T9" and "=Jan!Q20". I want column G to have all the same formulas as column F, except referring to the worksheet "Feb". So it would have "=Feb!T9" and "=Feb!Q20", for example.

So--is there someway to copy and paste a column of formulas, but changing the reference sheet from "=Jan!" to "=Feb!"? It would save a ton of time! Thanks for any suggestions, guys.

 

[pbt]

Highlight column G and do a Find of Jan and Replace with Feb

Harry

 

[bovinda]

Perfect--that was easier than I thought! Thanks for the help, Harry!

 

[pbt]

Glad it helped