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.
Bookmarks