Hi All
I need some help putting together a data table and then Graphing it but there are 2 areas I am stuck with:
1. The first problem I have is on the “Graph” sheet. The user can select in cell D7 either Commercial, Operational or Full. If full is selected then the current static table on the sheet would remain the same but if commercial is selected I would only want Direct Materials, Energy and Direct Labour to be shown. If Operational is selected I would want it to only show BFC – Other Prime, BFC – Overhead, BFC Depreciation, BFC Leases and BFC others – is that possible?
2. The second problem I have is I need a index/match formula which would match the branch in cell D6 with that on the “Cost Summary” sheet row 4 (column) and match the headings in the above data table with the “Cost Summary” sheet, rows 51 to 58 (to match the rows)
Can anyone help with either problem?
I have attached a sample file
Bookmarks