D
DTTODGG
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 are: 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.
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 are: 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.