Hi Forum,
I am wishing to automate a leave matrix. I have attached a spreadsheet with dummy data.
On one sheet is raw data. The are two sections of data, one for normal leave and one for special leave.
What I would like to have is a macro that will look at the data, and then give a value of "l" for normal and "n" for special (the matrix is formatted with Windings font so it gives a "dot" for normal and a "box" for special.
This value goes into the "Leave Matrix" sheet for the corresponding employee and date. The dates are inclusive.
There could be any number of rows of data in the raw data sheet
I have shown the first result for each leave type on the "Leave Matrix" sheet.
I am using excel 2002
Any help is greatly appreciated.
Thanks in advance
Koala