Forum Discussion
How to make one pivot with data from different sheet
I have tried to make one pivot from different sheet in excel but I didn't understand how can do that in this file in the Sheet STAT I have tried to import in one pivot all the data but now don't know...
Sorry I don't understand, I need to have one sheet with all the data in one place?
I have seen you example but I don't understand how can I merge the differente table in one pivot
- I was looking for a solution without that because all the data are continously updated so it will be better take the information from the sheet and make the merge in the pivot.
I will search on internet if I found something - how can I merge the differente table in one pivot
before pivotable, you'd better merge all sheets to one with addtional column sheet name.
after that,you can build the pivottable on this new sheet which enable you filter by sheet name.