Is there a way to have Excel add a row based off a drop down without using VBA?

[dskarin]

I am looking to have excel essentially unhide a row based off of a selection in a drop down box. The drop down box has multiple selections available and wanted to expose the proper row based on the drop down selection. Is this possible or does it need to be VBA?

Thanks!

 

[marc j]

Hello there,
I am not aware of any way to unhide a row "automatically" without vba, but you
can use conditional formatting to test a condition from your drop down box, and
then format the text to be "white" (invisible) or "black" (visible) or in your case "expose" (highlight)
the proper row.

Mike Girvin, Exelisfun on youtube has many videos on conditional formatting.
https://www.youtube.com/watch?v=FuPdQvOFZkw

Hope that helps!
marcj

 

[Fazza]

A parameterised query will return records, filtered from the input table/s, without VBA. So not by hiding or unhiding, it is more advanced than that. Without VBA a query can be set to refresh on changes to the cell containing the parameter value. Excel help & google will have examples.