Delete two cells in a row based on value in first cell then shift remaining cells left

I have been struggling to find any examples on this.

The attached worksheet has 20,000+ rows of information that I get daily. I have to remove the cell and it's corresponding cell based on the name in the first cell and shift everything left. Example in Row 2 I would need to remove the Name UPC and the corresponding cell with 85337239484 in it and shift the rest of the row left. To make it more interesting is some rows will have multiple items to be removed like in the 3rd row I have to remove MPN and Brand.

These are the Names and corresponding cells I need to remove throughout the entire worksheet: SKU, MPN, UPC, Brand, Seller and SME.

Try this (and test that it's not deleting any data it shouldn't before using it on live data)

*** incorrect code removed - see next post ***

oh sorry, missed the bit about the data in the corresponding cell. In that case, try

Please Login or Register  to view this content.