I have a timesheet which I want to Total. The Project Numbers are in Column
A, and the Days of the Month are in Columns B-M. The hours worked on each
project are reported in this form. All employees report their time in this
same Worksheet.
To Total this form, I want to do a VLookup down Column A for say ProjectA,
when I fnd it, I want to total the hours across that row. I may find
ProjectA multiple times in Column A (because of multiple employees using same
spreadsheet), and I want to continue to total the hours worked on Project A
all the way down.
Then, I want to continue doing VLookup for all projects. I have the project
list on a separate worksheet in the same file.
I have not used Visual Basic editor much at all, but I believe I want a
macro to do this. Could anyone please help?
Thanks,
Leann
Bookmarks