Hide and unhide rows
 

Why are you asking the same question twice.
BTW, URGENT gets no special attention here.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"percy/pista/johnny" wrote in message
...
I have a drop down Menu contains TANK1, TANK2 and TANK3
If we pick the Tank1 from drop down menu then the information
containing from TANK1(ie Row 12-18) should unhide similarly for TANK2
and TANK3
Pls help me out..its urgent.