trying to delete columns in a worksheet that dont match header values

I have a table that has several rows that is pulled daily. I want to delete all rows of data that does not have the 4 header values that I want to keep in the spreadsheet after the macro is run.

headers are in row 1

Thanks

Can you attach a sample file with some dummy data showing the beginning data and what it should look like after the macro is run (result). To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

sample 3 is correct file

This should work on Sample3.

Please Login or Register  to view this content.