Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Pivot table question
- Thread starter sabavno
- Start date
It can be done but.......I've never seen anyone that is happy with the results - it's very restrictive - you have to choose the "Multiple consolidation" option in the wizard and take it from there.
I would suggest that you create a mechanism for getting all the data into one place (via vba / links etc) and then pivot tabling on that Rgds
Geoff
Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur
I would suggest that you create a mechanism for getting all the data into one place (via vba / links etc) and then pivot tabling on that Rgds
Geoff
Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur
Or - in addition to Geoff's information - you can link via "external data source" option (step 1 of pivot table wizard) and selecting "excel files" (step 2, after clicking "get data" button). A named data range in source data is necessary.
combo
combo
The Pivot Table Wizard works quite well (I'm using Excel 97). If you're looking to create VBA code, look at my other threads regarding Pivot Tables as I've found some very interesting things lately and more or less logged them here at Tek-Tips. If I can answer my own questions I will; sometimes I get no replies but my own! 
It's part of the wizard, just tell the wizard where the other spreadsheets are and go from there.
Good luck! Onwards,
Q-
It's part of the wizard, just tell the wizard where the other spreadsheets are and go from there.
Good luck! Onwards,
Q-
- Status
Similar threads
