Vlookup
 

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

Vlookup
 

Can you add a column to total the hours in each row? Then use

=SUMIF(range, criteria, sumrange)

where
range = absolute reference to your project numbers in column A
criteria = relative reference to the cell with the project number you want
sumrange = absolute reference to the column of your timesheet with the row
totals

then copy the formula down the length of your project list.

"Leann" wrote:

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