After copying the sheet

Easiest might be editreplace

what: Jan

with: Feb

replace all.


Gord Dibben MS Excel MVP


On Mon, 27 Nov 2006 14:55:02 -0800, klnmis
wrote:

I have a worksheet that I would like to copy to a 3rd worksheet.
One of the formulas in the 2nd worksheet is =Jan!G7. This brings a balance
forward to the next month. So in the 3rd worksheet I would like that cell to
say =Feb!G7 and so on for the year.
There are several of these references throughout the worksheet. I would
like to copy these all at once and paste them to the next worksheet in one
shot.
Is this possible?