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

Thanks, it looks like that will work fine. 

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

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

Hello Sunny,

Thanks for your help, I moved it and corrected it, and it works fine.

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.