Showing only relevant, non-blank rows/columns

[Stealthjaint]

I want to be able to choose items from 10+ drop-down menus (linked to another sheet) in A2-A11+ and have the row that corresponds to each item be displayed (from another sheet?), but then hide columns with all blank cells between B2 and F+11+. What would be the easiest way to combine these two functions in Excel 2003?

 

[Tafq]

Can you please be a bit more specific. I do not understand what you mean when you say the balnk columns should hide. That will cause your other drop down cells to hide as well. How then do you intend to change the hidden drop down lists?