| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOKUP TO RETURN MULTIPLE VALUES | Excel Discussion (Misc queries) | |||
| Lookup and Return Multiple Values | Excel Worksheet Functions | |||
| Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
| how to lookup a value and return multiple corresponding values | Excel Worksheet Functions | |||
| Lookup with multiple value return | Excel Worksheet Functions | |||
Linear Mode
