I’ve been meaning to redo the original post with an example that uses tables, because it simplifies things a bit.
Static dates and times will not change but dynamic dates and times will change as time progresses.
I’ve made a new version of the post that takes advantage of Excel tables, which simplified the process a bit (it’s still kinda’ complicated).
That post is available here.][This post is about dynamic named ranges in Excel 2007.
I like to just have the first worksheet as the presentation layer — let’s name it Dashboard — and the second worksheets as the data layer — let’s call that Data.
(Note: I abhor many, many things about Excel’s default settings, but, to keep the example as familiar as possible, I’m going to leave those alone.
This basic approach is one of the core components in the dashboards I work on every day, and it can be applied to a much more robust visualization of data than is represented here.