formula for a formula

[JOhn Smith]

Hi,

This is a tricky one, but I'm hoping somebody can help me.

I have a file with a series of sheets based on date. There is one sheet
for each week. Any one sheet has many references to the sheet before it.
E.g in the sheet called Jan8, there are many references to Jan1, as in
"=Jan1!D33", "=Jan1!H33", etc.

Each week I add a new weekly sheet, copies from the previous sheet, but
then I have to manually update about twenty references. The actual cell
reference remains the same, but the sheet name changes.

Is there any way I could automate this. It would be really nifty if it
could be done from the sheet name, but even if I had to change the
reference once, that would be OK !!

Any ideas would be greatly appreciated,

Thanks,
Paul
(as you may have guessed, the email address is a furphy)
(a real address is -thegerm at netspace dot net dot au-)

 

[mrorwell]

in the sheet called Jan8, there are many references to Jan1, as in
"=Jan1!D33", "=Jan1!H33", etc.

Each week I add a new weekly sheet, copies from the previous sheet, but
then I have to manually update about twenty references. The actual cell
reference remains the same, but the sheet name changes.

Find "Jan1!" and replace with "Jan8!" should make the change in all of your
formulae at one time.



.................................................................
Posted via TITANnews - Uncensored Newsgroups Access-=Every Newsgroup - Anonymous, UNCENSORED, BROADBAND Downloads=-