It's been a while since I've last participated with you guys/gals here in the forum. Our company has downsized and I lost my right hand gal who kept up with my Employee files for me.
Attached is a small sample xls file(I removed actual names and info) to give you an idea what I'm trying to accomplish. I created this file years and years ago and it has done it's job, but I'm trying to spiffy it up now that my right hand is gone.
Task at hand is trying to enter dates as the employees request vacation on Worksheet "Input Data Vac 13" and get VBA to automatically write the employee's 1st and Last name over in the Calendar on Worksheet "2013 Vac Calendar".
I'm currently stuck in trying to come up with a way to perform this task.
Any guidance or push from the forum members to find a solution will be greatly appreciated.
*EDIT*
New Employee Workbook example attached to post#6
I revised the layout in the calendar and eliminated the merged cells to make it more VBA friendly...and added VBA code.
Bookmarks