Hi
Example.xlsx
I would like to create a table which reports values from various sheets, depending on which options I select for the table.
In the attached example I have sales data on three sheets: Cheese, Milk and Yoghurt. The format of each sheet is exactly the same, only the Brand Names are different (although I have the same number of brands on each sheet).
I want to create a summary table on Sheet 1, where I can select 3 parameters in each of the yellow highlighted cells, and it should return a table for me:
1. Cheese/Milk/Yoghurt
2. Low Fat/Full Cream
3. East/West
For example, in the table, I want to return the value for Cheese, Low Fat from the East. The table should list all brands (Brand V to Brand Z) along with the sales values.
Hope I’m explaining myself clearly!
Bookmarks