Hi

I have a spreadsheet similar to the below which is updated weekly

A B C D
NAME WEEKLY SCORE WEEKLY SCORE MEETING HELD
John Smith 250 230
01/11/2009
Jane Smith 105 10
07/12/2009

I insert a new column at the beginning of every week to enter in the new
score so we have a continual track. I want to create seperate spreadsheets
for the team managers for their employees which will update with Column D I
started by simply putting =(spreadsheetname!d2) which is fine until I insert
a new column. Is there a formula that will take into acount the insertion of
a new column each week and still provide me the date from "MEETING HELD"?

Hope this all makes sense
Thanks

Ruth