CALENDAR

  • Thread starter Thread starter Mark Whitehead
  • Start date Start date
M

Mark Whitehead

I am using Excel 97. I have created holiday worksheets
for each member of staff at my work where dates are
entered showing to and from when a member of staff is away
on leave.

I want to be able to plot each staff sheet on another
worksheet which acts as a planner. A years dates are down
column 'A'.

I have managed to pick up each staff sheet and put them
across the top in row 1 but now want to be able to pick up
the dates of the individuals entries and plot them.

Can anyone assist me with some code please?

Thanks in anticipation

Mark
 
Back
Top