Hello friends,

This is my first post and I think this forum has really brilliant people cooperating.

My inquirie is that I would like to create a macro in excel that can hide and unhide columns automatically when a cell value changes.

ie. When A1=pizza hide column d and show column c
When A1=burger hid column c and show column d

I want to apply this macro to a file that contains a lot of columns for each type of information.

I will appreciate any help I can get about this.