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?