Referencing cells

[jackdiamond]

Apologies as I posted something like this earlybut explained it completely wrong and it didn't make sense, so here goes.

Imagine cells A1:A100 have fixed dates.
Cells B1:B100 can have dates entered.

An example:
Cell A1 has the date 23/09/11
Cell B1 is referenced to A1 so that it reads the same (23/09/11)

When I insert a cell above B1, it will push it down but still reference A1 but I now want it to reference A2 or which ever number of cells it has been pushed down by.

Does this make sense?

So however many cells "B1" moves down, I want it to then reference whatever cell it is adjacent/parallel to in the "A" column

Any help appreciated
Ta
Stu

 

[Joe4]

Duplicate:
http://www.mrexcel.com/forum/showthread.php?t=541240

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).