Dear community,
I am struggling for days with the following problem:
- I have several sheets in an Excel file
- All sheets have the exact same table format (same column names and same number of column)
I would like to create a "Recap sheet" in which there is the same table format as existing sheets that would aggregate data when I filter it. To be clearer. I would like to be able to select a column filter and then, the data automatically aggregates (retrieving all the lines from all sheets that meet the selected filter).
I added a sample file with three sheets, each sheet contains the same table format with four columns: Edition / Name / Quantity / Type
I would like to create another sheet with a table with the same number of column (of if I can select which one it is even better). I tried Pivot Table reports, I tried external data queries ... without success :-(
Many thanks in advance for your support and I hope I have been clear enough.
PS: the actual file with the data contains table with 10 columns and between 200 and 500 lines each. The table will evolve with time with new sheets added to it.
Mathieu
Bookmarks