reference question

  • Thread starter Thread starter david
  • Start date Start date
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
 
Hi!

=INDIRECT("B1")

That will always refer to cell B1 even if you insert a new column B every
day.

Biff
 
Back
Top