Un-Hiding and Hiding Columns based on Drop-Down Values in a Column.
Dear Forum,
I have a requirement to Hide Certain Bunch of Columns based on the value in the cell which decides the fate of all these columns..
I have a Column in which I have a drop-down where there are 4 Elements to store the 4 most used Modes of Payments such as below:
Cheque
Cash
RTGS/NEFT
Credit Card
Just want to Un-Hide the Relevant Column on selection of the Drop-Down and Hiding the other columns and again Hiding the column when the entire data entry for that mode is done..
Warm Regards
e4excel
Bookmarks