Macro to search headings of a column and hide if it contains a word contained in a drop down menu

[peterjackson12]

Cell A1 contains a drop down menu which contains different headings - so cat dog etc

I have a large spreadsheet, each column is headed with either cat dog etc in row 4

I would like the macro to automatically read what is selected in the drop down cell, and look at each of the headings in row 4, hiding any of the columns that do not match that of the drop down.

And if nothing is selected in the drop down menu I would like all of the spreadsheet to be visible

 

[dave3009]

I'll assume you have some kind of dynamic list for your drop down, how is this list defined?

So if the column exists then only hide that column...or hide every column in the list?

If the cell with dropdown is blank then everything is shown?

 

[peterjackson12]

Thank you for looking at this.

The aim was that if you select cat for example from the drop down list, the macro looks at each column heading and if the heading says cat the column stays, if the heading does not say cat then the column becomes hidden.

So if you want to see just the columns containing cat as the heading you select cat in the drop down menu.

If you want to see just the columns containing dog as the heading you select dog in the drop down menu.

All of the other columns then become hidden.

The list is defined as ColumnHeadings