Can you delete a column based on a cell value?

[iwilli]

I have a report I download weekly from the corp. site. It contains sales stats for the previous week. I spend a lot of time rearranging the data so I can prepare weekly presentation for several managers. I built macros that deleted the column I don't need and that really sped things up. But know for some reason corporate keeps changing the format and my macros are deleting the wrong columns. Is there VBA code that will search for specific text in the first row of each column and delete the column if it doesn't match?

Cross Post: Excel Forum

 

[Safety Guy]

Yes, I understand that this thread is 5 years old, but I didn't want to start another thread on the same topic.

Background: My company uses a cloud based company to track employee hours. Every month I run a report from said site and download it as an Excel worksheet. Unfortunately, there are several columns that I don't need as I am after only the actual hours worked and the report includes vacation hours, FMLA hours, etc. so I need to delete those I don't need. I would just record a macro, but the columns are dynamic and can vary month to month. Hence, the VBA route.

Now my issue: I am having a problem with the module/macro/sub-routine working with the downloaded sheet. It will delete all columns except column A. If I start with a fresh workbook and type the headers in, everything is sweet. Can someone explain to me what the blazes is going wrong????

Thanks,
Safety Guy