Hello!
Looking for some assistance with a macro to archive data that is entered weekly... I attached a sample spreadsheet.
Each week, data is entered into the 1st worksheet (Time Card Calculator) to calculate each person's hours. I clear the data after each person. Instead, I would like to paste this info to a new worksheet (Sheet3) so I have a summary of each person's hours for the week.
In more detail, I would like to paste the values of cells M13:P13 (Time Card Calculator worksheet) to cells M:F (Sheet3), the row being determined by cell B1 of the 1st worksheet.
Thanks in advance for any guidance anyone can provide.
-MM
Bookmarks