D
david
I have a cell 'A1' that references a cell in another (unsorted) column 'B'.
Every day I add a new column of info to the worksheet by inserting a
column. Column B then becomes Column C.
As a result of the insertion, cell A1 now references a cell in column C-
the previous day- but I want it to stay referenced to the (new) column B.
I've read about absolute references and played around with INDEX and
LOOKUP functions, but I haven't figured out how to do it, though I'm
guessing it's pretty simple.
Your help appreciated!
David
Every day I add a new column of info to the worksheet by inserting a
column. Column B then becomes Column C.
As a result of the insertion, cell A1 now references a cell in column C-
the previous day- but I want it to stay referenced to the (new) column B.
I've read about absolute references and played around with INDEX and
LOOKUP functions, but I haven't figured out how to do it, though I'm
guessing it's pretty simple.
Your help appreciated!
David