Good morning all
I have created a dashboard which will be printed every week and using Excel using the data refresh the data in tab 2 will update
The spreadsheet has two tabs the first tab the dashboard, which I call the wall and the second the data.
The data is really simple and don't need to do anything complicated with it just need it to pull through into the right boxes and that's where I need the help.
For example in the data tab for Monique (Primary Owner, column D) I need the Definition, Aspiration and cost cell information from the row pulled through into the right location which is determined by the spin cycle stage (column B in data tab) on the wall
In this instance Monique is in stage Build so I need the information from the Definition, Aspiration and costs to pull though to the first tab the wall and appear in the Build area of boxes, and not the others.
I assume an index match would work for this?
However, at some point the data tab will refresh once the data refresh is pressed and Monique will move from Build to Implemented so will need that information from Definition, Aspiration and costs to move down into the boxes in the Implemented area.
Hopefully this makes sense.
For now I just want to get that mechanism to work before looking and with more rows making other 3 work and see if this is possible.
I'm pretty sure it is with the right formulas but this is where I need help.
Hopefully, fingers crossed someone here can
Thanks
Matt
Bookmarks