Log In
Register
Home
March 29, 2019
Offline
Hello,
I want display budget reports by program, maybe through a dashboard. I have attached a sample file. I want to be able to choose Admin and it would display columns A to H. If I choose HDM, it would display I to O. I have about 13 different programs. I don't need to print it, just would like to make it an interactive workbook or dashboard. Any ideas?
Thanks for any help in advance.
See Answer
VIP
Trusted Members
June 25, 2016
Offline
Hi Todd
You can try using Data Validation with an Event macro to trigger the display.
My example require you to define the selection and their range in the Setup sheet first.
When you select it from the drop-down list (cell A1) in your report, the macro will display the range defined by you in the Setup sheet.
Good luck.
Sunny
Answers Post
March 29, 2019
Offline
Thanks, it looks like that will work fine.
March 29, 2019
Offline
Hello, finished my workbook. I tried to copy the code from Visual Basic to get the columns to display. My selection cell is B49. Can someone help me out?
I had some Visual basic in college about 15 years ago, so I am pretty much lost.
Thanks in advance.
Todd
VIP
Trusted Members
June 25, 2016
Offline
Hi Todd
1) Your code should show $B$49 instead of B$49$
2) It is not good to put the validation on a column that will get hidden. Try putting the validation in another location instead.
You will then need to change the $B$49 to the new range.
Sunny
March 29, 2019
Offline
Hello Sunny,
Thanks for your help, I moved it and corrected it, and it works fine.
Power Query
Power Pivot
Power BI
October 17, 2018
Offline
You could also try Custom Views under the View tab. Set up the view that you would like to see for each scenario by hiding columns or rows and add it with a name it under Custom Views. Don't think it will work with data in a table, but no coding involved.
1 Guest(s)
