Hi all,
To make things easier I have added a workbook with a userform attached.
When you press the edit data button, you get an userform. It has 4 comboboxes and a OK and exit button.
The idea is that when you click on the edit data button you will be able to select a person, choose the date from, choose the date to and the reason. the only thing that will be filled in by the userform is the reason in column E. Maybe it is better to say that when you select the person and the dates, it will create a range for that person in the chosen dates and only fill column E with whatever the choice was.
In the workbook I have added a sick leave period from the 12th 11 till the 19th 11 for Jesica Poter.
Any ideas getting this going?
Greetings.
Bookmarks