Hi guys
I would appreciate some help with a piece of Excel VBA please. Essentially, I'm creating a database of staff vacation (annual) leave. This is stored in the format below.
tblLeave
entry staff_id staff_name leave_start leave_end 1 9991 Marie Smith 31/12/2012 04/01/2013 2 9994 Richard Owen 28/01/2013 01/02/2013 3 9991 Marie Smith 11/02/2013 12/02/2013 4 9998 Jennifer Muller 14/01/2013 18/01/2013
What I need is a piece of VBA code that will look at the dates (that will be extracted using a SQL string from a .mdb file) and will loop through the results, marking an "A" (for annual leave) against the member of staff's name and under the correct date on the attached calendar (I've used January 2013 for an example).
Calendar Example.xls
My real issue is how to get VBA to understand how to mark the days in between the start and end dates as "A" (especially if they span into another month).
Any help or pointers would be much appreciated.
Kind regards
Paul
Bookmarks