Hi,
I have a dashboard in which the user can select All, Branch 1, Branch 2, Branch 3 etc to Branch 6.
Depending on the selection I need it to pull in data headings to be used on my dashboard – would a lookup do this?
I have uploaded an example which should explain it more clearly but this is what I want to achieve...
If branch one or two is selected it would display the following in the blue box on the dashboard (Cell B80):
INVENTORY ANALYSIS
Campaign
Commodity including Downstream finished goods
Automotive
Buffer Stock
Raw Materials, work-in-progress and stores
If branch 3, 4, 5 or 6 is selected it would display the following in the blue box on the dashboard (Cell B80)
Raw glass
Interlayer
Other raw materials
Semi-finished - goods in transit
Semi-finished product awaiting further processing
Work-in-progress - within production process
Finished goods
Trading Goods
Trading goods in transit
Maintenance spares
Other stores
TOTAL NET STOCK
If all is selected then the blue box on the “dashboard” sheet would display all of the above (As in the example of the spreadsheet - not displayed here)
The branch selection is linked to cell D4 on the “Calcs” sheet
All the lists can be found on the “Calcs” sheet range C97:C114
Any suggestions?
Bookmarks