Hi Jac

Multiple Consolidation does work in a different way.
Take a look at Debra Dalgleish's site for more information on this
http://www.contextures.com/xlPivot08.html

--
Regards

Roger Govier


"Jac" wrote in message
...
hi,

When I used Pivot Table to consolidate data from different ranges in
different sheets, the created table will have the field buttons
labeled as
"Row" & "Column" instead of the actual names of the row and column,
for
example Order ID, Company Name.......

I'm wondering whether there is any way that we can change the field
button's
caption from, for example "Columns" to Company Name????

Anyone out there has any ideal of doing so???
Please advice, thanking in advance!!!