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