On the attached .xls I would like to build a macro which shows me on sheet 2, 6 months in advance who will be off, but necer show previous dates. The columns in sheet 2 should show the following:
1. Date = 1-999 which dates are coming up first at the top.
2. Day = Monday/Tuesday etc.
3. Time off should pull the data from sheet 1 to show how long they are off for i.e. 1 day .5 day etc.
4. The staff names = Just put the word 'Yes' in the row under the member of staff it corresponds to.
Any help is greatly appreciated.