Only showing certain columns depending on a condition

Hi

I have managed to create a spreadsheet that is going up to column HM! but trying to sort columns or data in here is fairly hard, and without using the find function then copying and pasting into a new sheet, is rather annoying.

Im wondering if there is a code i could use that would.....
1. only show me certain columns depending on a conditon
2. always keeps column a unhiding
3. can easily unhide all columns

I have attached an example as i may not be explain it brilliantly, but have come to a conclusion i am wasting around 3-4 hours a week copying and pasting, when i surely can have a macro/command do this?

If anyone has any suggestions, help or advice i would be very very grateful

Thank you

Danexample10.xlsm

I would be very wary about having your cell entry column (B1) be a potential candidate for a hidden column. Example: What if you put apple in B1? It would hide column B, so you would have to unhide it, just to put in a new value into B1. Also, one of your examples was "KIWI" while some others were "kiwi". You didn't specify how you wanted to approach capitalization so I made it capitalization specific.

Please Login or Register  to view this content.

Hi stnkynts

Thats perfect it works exactly as i want it to thank you very much

Dan