Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel |