Hi,
I am creating a excel calendar to record and monitor holidays and sickness
I have sheet 1 with two calendars start and end date, I have a combo box filled with names to select and a button which you click to add the selected information to sheet 2, the problem i have is as the dates are only stored as a start and end date on sheet 2 I can not look up dates in between to prevent two people being off at the same time.
could some one point me in the right direction to solve this thank you
I am creating a excel calendar to record and monitor holidays and sickness
I have sheet 1 with two calendars start and end date, I have a combo box filled with names to select and a button which you click to add the selected information to sheet 2, the problem i have is as the dates are only stored as a start and end date on sheet 2 I can not look up dates in between to prevent two people being off at the same time.
could some one point me in the right direction to solve this thank you
