Excel macros and VB
Posted by Bob Vanjoff on January 11, 2002 10:38 AM
I am looking for some advice. I have an Excel spreadsheet that I track my team's attendance with. There is a row for every day of the year, and each day has 3 different time entries. My timekeeping system will allow me to generate Excel reports for my teams daily punches. What I want to know is if it is possible to write a macro, or use visual basic to have Excel look at the daily report, find an employees name, copy the total hours from that report and then paste it into the big tracker sheet. I think it boils down to how easy or hard would it be? Thank you very much in advance for any advice anyone may have.