Relative referencing does not work between sheets so you either have to use a
macro, UDF or do an edit replace

http://tinyurl.com/4ftky

Regards,

Peo Sjoblom


"RonMc5" wrote:

I use a workbook with 53 sheet to keep track of mileage info for expenses.
There are two references to the previous sheet. EG: Current sheet is sheet5!
I need to reference a cell sheet4! . I can do this now, but if I copy sheet 5
to sheet 6, the reference is still to sheet 4, instead of to sheet 5 so I
have to edit the refering cell each time to I copy to a new sheet. 51 times!
:) The last sheet is for summaries and totals and tax info.

I think I should be able to say sheet(-1)! . That looks like a good syntax
to me! :)

Any work arounds please?