Posted to microsoft.public.excel.misc

Kevin Clark[_2_] Kevin Clark[_2_] is offline

external usenet poster

Posts: 7

Pivottables - Can i consolidate 2 Data sources in Excel 2007?

I have two tables in two worksheets in one workbook.
They have identical column headings.
Can i create one Pivottable consolidating all of their data?
I can find info for Excel 2002 but not 2007.

Thanks in advance.
Kev

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
Excel 2007 and External Data Sources	Bettie Claxton	Excel Discussion (Misc queries)	0	August 15th 07 04:56 PM
Consolidate in Excel 2007 and 2003	Diamontina Cocktail	New Users to Excel	8	May 14th 07 09:41 PM
In Excel 2007 PivotTables, what happened to "hiding" subtotal line	Aurelio	Excel Discussion (Misc queries)	6	February 21st 07 11:21 PM
Two Excel Data Sources	Stephanie	Excel Discussion (Misc queries)	1	February 5th 07 02:07 PM
PivotTables and OLAP sources	Gilles Desjardins	Excel Discussion (Misc queries)	0	February 11th 06 10:49 PM

All times are GMT +1. The time now is 11:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us