Delete columns based upon a column heading?

Hi,

Can anyone help me with the following?

I have hundreds of columns of data in my spreadsheet. Each column heading in row 1 is just a number (510,24,12 etc).

Is there a way of saying “if the column heading figure is >100, then keep the column, if not delete the entire column”?

I can’t filter on the rows and there is too much data for a pivot table to handle.

Thanks,

Hi

Try this:

DELCOLUMNS.xlsm