software

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!

GBT
The sheet name will not update like a cell reference. What you will
have to do in the new sheet is replace all the 22s with 23s.
Do this:
Select the new sheet.
Click Edit - Replace
In the quot;Find what:quot; box, type quot;-22-quot; without the quotes.
In the quot;Replace with:quot; box, type quot;-23-quot; without the quotes.
Click on quot;Optionsquot;
In the quot;Look in:quot; box, select Formulas.
Click Replace All
Done
HTH Otto
quot;GBTquot; gt; wrote in message
news
gt;I need a cell reference to another sheet to move as I create succeeding
gt; sheets. E.g. I name a sheet 03-22-06. The next day, I copy this sheet to
gt; create 03-23-06 and on this sheet I reference cell A1 on the 03-22-06
gt; sheet
gt; (i.e. = '03-22-06'!A1). Now, on 3/24, I create sheet 03-24-06, but on
gt; this
gt; sheet I want my reference to give me the data in = '03-23-06'!A1. What I
gt; get
gt; now is = '03-22-06'!A1.
gt;
gt; Thanks for your help! It's most appreciated!