referencing cell contents, after deleting and shifting new contents into cell

[HM]

Greetings all,

on Sheet 2 of my workbook I reference some cells from Sheet 1. ie.
"=Sheet1!D3"

I have Sheet1 setup as a schedule. Since sheet1 is a schedule, its columns
are days of the week.. and I constantly add days to the end of it (Columns
F,G,H,I..etc..etc). When today is over, I delete columns A and B, and
columns C and D shift over and become the new A and B.

However on sheet 2, the reference is lost even though new values are shifted
over into Columns A & B.

Is there a way for the Sheet2 to keep the referencing A and B from sheet1
once the columns in Sheet1 are deleted and new information is shifted to
into them?

Thanks in advanced,

HM

 

[dcronje]

You can try use

=INDIRECT("Sheet1!D3)

Davi