View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GBT
 
Posts: n/a
Default 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!