I'm working on a Dashboard that provides a Summary of all the important information that our management needs to run our business. I had the idea of a section last night and wanted to get some feedback as to the possibility of it. Basically, I'll be linking to a query in an Access Database that contains all of the expense records (from Quickbooks via QODBC) for each of our departments (Sales, Marketing, etc.) It will also have a field/column for the month.
What I have now is a table that has departments for rows, and months for columns, that totals the records for each combination (Sales-Feb, Marketing-Jan, etc.)
I'm wondering if it's possible to write a VBA script that, when you click on any of those combinations:
1. opens a new workbook
2. writes all of the records for that "clicked" combination
Is that possible and/if so, extremely difficult?