copying sheet references that refer to a cell in the preceding she
I need a cell reference to another sheet to move as I create succeeding
sheets. E.g. I name a sheet 03-22-06. The next day, I copy this sheet to
create 03-23-06 and on this sheet I reference cell A1 on the 03-22-06 sheet
(i.e. =+'03-22-06'!A1). Now, on 3/24, I create sheet 03-24-06, but on this
sheet I want my reference to give me the data in =+'03-23-06'!A1. What I get
now is =+'03-22-06'!A1.
Thanks for your help! It's most appreciated!
|