coliervile
05-22-2006, 02:19 PM
Good afternoon everyone. I want to thank everyone that have posted different VBA's thus far that have helped me on my quest. I'm a new member and a true novice at VBA.
I have an Excel 2000 database that track employees requesting vacation/leave requests. On one sheet, named "Leave Request" all employees request go in this database and looks like this:
NameRequestedTypeStartEndAA22-May-06Prime Time1-Jun-064-Jun-06
What I want to do is to look-up all request of one emploee (e.g. "AA") in the data base and copy all of their leave request results to another sheet called "AA Request" and the format of this sheet is exactly the same as above. I would also like to do the same except that I want to use each day of the year and the results would render all employees that requested time-off that day and put the results in a sheet named "Day to Day.
Thanks for you help.
Charlie
I have an Excel 2000 database that track employees requesting vacation/leave requests. On one sheet, named "Leave Request" all employees request go in this database and looks like this:
NameRequestedTypeStartEndAA22-May-06Prime Time1-Jun-064-Jun-06
What I want to do is to look-up all request of one emploee (e.g. "AA") in the data base and copy all of their leave request results to another sheet called "AA Request" and the format of this sheet is exactly the same as above. I would also like to do the same except that I want to use each day of the year and the results would render all employees that requested time-off that day and put the results in a sheet named "Day to Day.
Thanks for you help.
Charlie