I've been working on creating my own dynamic dashboards using the 4 part series on this site, and it has been going very well (Thank you!).
However, I have decided I want the ranges on my data to be dynamic as well, which this series does not cover. I have utilized several resources to help create these dynamic ranges, but I am having trouble linking these ranges to the dynamic tables which are below our dashboards (as in the 4 part tutorial).
I know that my ranges are set up correctly (using offset function, and verifying the range location with f5). But in the tables, its returning #Ref! errors.
On Kyd's site, he talks about using the dynamic ranges to feed back into a database, which links to the dashboards. ( http://www.exceluser.com/dash/digest/setup/pnp-02-db-to-dashboard.htm )
So is it possible to use the dynamic ranges when building dashboards/tables as shown in the 4 part series, or do you have to link them back to a database?
If it is possible, any suggestions about what may be going wrong?