Dashboard Details via "Link"
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?
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?
ASKER
Coming up.
ASKER
This shows what I'm talking about. Cols. A-C represent the data that I will link to/import into Excel. The summary table will sum up the departments...and when you click on one (yellow one; Marketing/November), I want it to create a new workbook with the details behind the number.
Dashboard-Question.xls
Dashboard-Question.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Wow! That is awesome. It gave me an error initially, but when I clicked "End", it still opened the file. I changed the path, and it saved it fine. But it then didn't open the spreadsheet automatically. How can I add that function (back)?
If you want to see the spreadsheet then delete the line
wb1.Close
Sid
wb1.Close
Sid
ASKER
Man,that is fantastic! Thanks, Sid. People like you have really helped expedite my learning. I have questions, I ask for help, and then I'm able to read the code to gradually learn how all of the pieces (of code) work. Thank you very much for taking the time to help.
You are welcome :)
Sid
Sid
ASKER
I almost feel like it's cheating getting such AMAZING and quick help. You guys make me look like a Rock Star at work!
Sid