lookup across multiple sheets & return sum of cells

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

Sheeloo

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

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

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
 
S

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

se7098

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

se7098

hi Sheeloo...thank you for helping me.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top