Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Consolidate Woorksheets
Hello-
I'm having a problem consolidating several worksheets. I've looked in Excel help, but when I get to the Consolidate Window, I have a limited amount of functions to choose from - none of the say "position" or "category" or "3-D". Am I in the wrong place? The only functions I have a sum, count, average ... varp I was given a workbook that had 5 worksheets with different salespersons info. I think I would like to consolidate the data and then use pivot tables. Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to consolidate data from multiple worksheets. | Excel Worksheet Functions | |||
consolidate 2 different workbooks | Excel Discussion (Misc queries) | |||
Clean Up Code - consolidate steps | Excel Discussion (Misc queries) | |||
Consolidate data from several worksheets via pivot table | Excel Worksheet Functions | |||
Consolidate list from multiple worksheets | Excel Worksheet Functions |