LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8
Default Pivot Table to reference multiple sheets

I need to create a pivot table that references the data from 2 worksheets.
I have tried the consolidation method but am confused when the field list
does not carry over my column names.
Can someone please advise?
Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Single Pivot Table 4 Multiple Sheets? FARAZ QURESHI Excel Discussion (Misc queries) 2 June 11th 07 08:37 AM
Pivot table from multiple sheets - odd result Dianna S Excel Discussion (Misc queries) 0 June 6th 07 04:17 AM
Pivot table for multiple sheets Barbara Excel Discussion (Misc queries) 1 December 21st 06 09:11 PM
Pivot Table from multiple sheets Joël Excel Discussion (Misc queries) 1 June 21st 06 03:29 PM
Pivot Table--How can I create from multiple sheets? penciline New Users to Excel 3 February 22nd 06 06:25 AM


All times are GMT +1. The time now is 06:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"