How can I build a pivot table from multiple worksheets which are .

Richard Stephens

Posts: n/a

How can I build a pivot table from multiple worksheets which are .

I need to analyze about 60mb of data on different speadsheets in Excel. I am
attempting to build pivot tables to look at the data.

How do I build pivot tables from several different worksheets in a workbook?
All of the data is in columns with column headers but I can't seem to get it
to pivot correctly to give me the results I need.

Please help...

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Using a Pivot Table Calculated Field to get a Unique Count	Mike Struckman	Excel Worksheet Functions	1	November 22nd 05 05:32 PM
How to have multiple columns in pivot table data area?	mitch1962	Excel Worksheet Functions	1	February 24th 05 01:22 AM
Product Function in Pivot Tables from Multiple Consolidation Range	bbishop222	Excel Worksheet Functions	0	February 22nd 05 04:55 PM
copy pivot table to multiple worksheets	Todd	Excel Worksheet Functions	2	November 19th 04 03:16 AM
Problem with Pivot Table Drop-Down Menus	Mac	Excel Worksheet Functions	4	November 7th 04 01:18 PM

All times are GMT +1. The time now is 10:51 AM.

Menu

About Us