Multiple Worksheets & PivotTable
 

I think I can use a Pivot Table to summarize multiple spreadsheets....is this
correct? I have tried to read the help sections on this but can't come up
with the answer. Now, I turn to you. I have two worksheets that use the
same field names. One worksheet has 50,000 lines and the other has 15,000
lines. Should I consolidate or Pivot Table? I have experimented with
both...but it's not working out and I think it's probably me. Can you give
me some advice and maybe some additional information such as which options to
use in wizards and what ranges I use...for example....do I include field
titles in the ranges for both spreadsheets?
Many thanks
--
Gator

Multiple Worksheets & PivotTable
 

Have a look at this information from Debra Dalgleish's excellent Contextures
site:
http://www.contextures.com/xlPivot08.html

Hope this helps,

Hutch

"Gator" wrote:

I think I can use a Pivot Table to summarize multiple spreadsheets....is this
correct? I have tried to read the help sections on this but can't come up
with the answer. Now, I turn to you. I have two worksheets that use the
same field names. One worksheet has 50,000 lines and the other has 15,000
lines. Should I consolidate or Pivot Table? I have experimented with
both...but it's not working out and I think it's probably me. Can you give
me some advice and maybe some additional information such as which options to
use in wizards and what ranges I use...for example....do I include field
titles in the ranges for both spreadsheets?
Many thanks
--
Gator