Un-Hiding and Hiding Columns based on Drop-Down Values in a Column.

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

Kindly delete this Thread as it is a Duplicate Post due to SLOW INTERNET SPEED