hi guys,
i have created following table in excel and i want to add a drop down button to yellow marked area to VIEW SOME SPECIFIC coloumns WITH SELECTION.
there are 5 M/A Types and when i select type 1 i only want to automatically hide coloumn G and H,
like wise when i select M/A type 2 i want to hide coloumn I and J,
because i expect to enter multiple tables in single excel sheet. for the ease of use i want to select the table no in drop down for hide the unusable coloumns. help me to do this
Capture.JPG
Bookmarks