Thread: Vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LeAnn LeAnn is offline
external usenet poster
 
Posts: 18
Default 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