lookup across multiple sheets & return sum of cells

  • Thread starter Thread starter se7098
  • Start date Start date
S

se7098

i have a workbook with 10 worksheets...labeled with employees name

i am creating a summary sheet that i want to return the sum of each function
performed by the employee into a single cell.

i.e., lookup contents of cell a3 on all worksheets and return sum of cell b3
for all employees/worksheets.

is this possible? thanks.
 
Looks like you will have to use a macro...

What is in A3?
Do you have any experience with macros?
 
A3 contains the function being performed...i.e., mining resumes

i have some experience with macros but am by no means an expert.

Thanks Sheeloo
 
Let me know which cells to copy from Main sheet (criteria for selection) and
where to post on each cell...

I will write the macro for you.

Best would be if could send me a mail with sample data...
 
ok...how do i email you directly?

Sheeloo said:
Let me know which cells to copy from Main sheet (criteria for selection) and
where to post on each cell...

I will write the macro for you.

Best would be if could send me a mail with sample data...
Click to expand...
 
hi Sheeloo...thank you for helping me.

how do i send you a direct email with an attachment?
 
Back
Top