Register
Log In
Unanswered
Home
New Member
June 25, 2016
Offline
Hello,
I am requesting assistance in creating a pivot table from data spread out several worksheets. Basically, one pivot table summarizing data from several tables spread out in different worksheets. How can I do that? Is Power Query useful to achieve this?
I am using Microsoft Excel 2010 version 32-bit.
Any help and suggestion would be greatly appreciated it. I am very new to this so a detailed explanation would be greatly appreciated with some visuals if possible.
Singhg
July 16, 2010
Offline
Hi Singhg,
Power Query can help you consolidate the data into one sheet so you can use regular PivotTables as described here:
https://www.myonlinetraininghub.com/combine-excel-worksheets-with-power-query
Or Power Pivot can help you by allowing you to create relationships between those tables so you can create a PivotTable from them. An example of that is here:
https://www.myonlinetraininghub.com/power-pivot-does-vlookup
However, both of these methods assume your data is in a certain format and you know how to use these tools. If you want training on them then we can help you with that.
Mynda
Most Users Ever Online: 57
Currently Online:
16 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Akshatraj Adig
Liesie Marais
Moet Lewis
Michelle Anderson
Veronica Gallego
krishnaraj r
Dharan Prakash Mishra
Md. Rahman
Lilian Vo
Jane Kumwenda
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
