put in formulas that involve a structure like this or similar

=offset(MasterSheet!$A$1,row(),match(Indirect(Addr ess(1,column())),masterShe
ets!$B$1:$IV$1,0),1,1)

since you have multiple sheets, it would be more complex in that you would
need to determine which sheet and which column in that sheet.

--
Regards,
Tom Ogilvy

"Keith" wrote in message
...
I currently have a spreadsheet with all our employees down the A column
and then going across the top a calender. One column per day of the year
(it has to go over 2 spreadsheets). I then have a code that is input in
the grid to say what dates each employee is on holiday. I am looking
for a way to link another spreadsheet to this one, but only show the
columns relating to the current month and next month.

I can link in the first column with the employee's name as it is static,
but how do I get it to link only to this month and next month when it
changes each month?

I hope this makes sense.

Regards


Keith