Bill Stenson
New Member
- Joined
- Jul 24, 2016
- Messages
- 1
Hi,
This is my first post on here, I hope you can help
I am building a staffing plan for work. I have the weekly plan setup on sheet 1, which looks like this:
<tbody>
</tbody>
The annual leave for the week is on sheet 2 in the same format. I have been trying (and failing) to build a macro that will read the annual leave list for each day of the week, and delete anyone that is on leave on a given day.
The names in the weekly plan on sheet 1 are selected from a data validation so I can't use any formulas in the cells.
Any advice will be greatly appreciated
Bill
This is my first post on here, I hope you can help
I am building a staffing plan for work. I have the weekly plan setup on sheet 1, which looks like this:
<tbody> </tbody> |
<tbody>
</tbody>
The annual leave for the week is on sheet 2 in the same format. I have been trying (and failing) to build a macro that will read the annual leave list for each day of the week, and delete anyone that is on leave on a given day.
The names in the weekly plan on sheet 1 are selected from a data validation so I can't use any formulas in the cells.
Any advice will be greatly appreciated
Bill