Hello,
I've been using a revenue dashboard for a while now, with about 10 named ranges and a sheet full of dynamic tables to power charts.
I copied the dashboard, and replaced all the raw data with order data, and voila the revenue dashboard is now an orders dashboard.
I'm trying to combine the two so I don't need to send two files, and I'm thinking I will put a select box at the top for Revenue or Orders. My current thinking is that I will go into my orders dashboard, put "ORD" as a prefix in all the data sheets, and also in all the named ranges so there won't be conflict when I start moving sheets.
Then, I plan on putting in simple IFs to go between the two (using the named ranges, for example IF(X,ORDCountryPlan,REVCountryPlan). This will be quite a bit of work but I don't see any issues. Anyone have a better idea of how I can do this?
Raesu
I've been using a revenue dashboard for a while now, with about 10 named ranges and a sheet full of dynamic tables to power charts.
I copied the dashboard, and replaced all the raw data with order data, and voila the revenue dashboard is now an orders dashboard.
I'm trying to combine the two so I don't need to send two files, and I'm thinking I will put a select box at the top for Revenue or Orders. My current thinking is that I will go into my orders dashboard, put "ORD" as a prefix in all the data sheets, and also in all the named ranges so there won't be conflict when I start moving sheets.
Then, I plan on putting in simple IFs to go between the two (using the named ranges, for example IF(X,ORDCountryPlan,REVCountryPlan). This will be quite a bit of work but I don't see any issues. Anyone have a better idea of how I can do this?
Raesu
