lookup across multiple sheets & return sum of cells

[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.

 

[Sheeloo]

Looks like you will have to use a macro...

What is in A3?
Do you have any experience with macros?

 

[se7098]

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

 

[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...

 

[se7098]

ok...how do i email you directly?

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...

 

[se7098]

hi Sheeloo...thank you for helping me.

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