lookup across multiple sheets & return sum of cells
 

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.

lookup across multiple sheets & return sum of cells
 

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

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

--
Always provide your feedback...


"se7098" wrote:

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.

lookup across multiple sheets & return sum of cells
 

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" wrote:

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

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

--
Always provide your feedback...


"se7098" wrote:

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.

lookup across multiple sheets & return sum of cells
 

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...
--
Always provide your feedback...


"se7098" wrote:

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" wrote:

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

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

--
Always provide your feedback...


"se7098" wrote:

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.

lookup across multiple sheets & return sum of cells
 

ok...how do i email you directly?

"Sheeloo" wrote:

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...
--
Always provide your feedback...


"se7098" wrote:

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" wrote:

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

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

--
Always provide your feedback...


"se7098" wrote:

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.

lookup across multiple sheets & return sum of cells
 

hi Sheeloo...thank you for helping me.

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

"Sheeloo" wrote:

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...
--
Always provide your feedback...


"se7098" wrote:

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" wrote:

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

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

--
Always provide your feedback...


"se7098" wrote:

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.