I'm trying to have tables appear if a table is clicked on a multi-optioni dropdown list.

[Graham99]

Good Day,

I am working with a multiple drop down selection box and trying to configure a page to only show what is selected on the drop down. I would like each option in the drop down to populate a table which is only visible if the drop down selection for that table is checked. I hope this can be done!

For example - lets say i have 4 choices on my drop down, but the client i am going to visit could see some of the info as negative for his store. I only want to show the positive information at this time.

Here are the drop downs:

Total Coupons YTD
Total Credit Exceptions Made YTD
Total Special Credit Programs YTD
Supportive/Non-Supportive Client

This is a non-supportive client who has not utilized our coupon program, so I only want to show Total Credit Exceptions and Total Special Credit Programs on his report. I have 250 clients, and the information for each category above is fed into other tables by VLookup. What i want to do is have a table appear on the new sheet if the drop down selection is clicked.

Is this possible?

Thanks in advance for the help.

Tim