Excel Find and replace multiple values from a list
Hi, I was wondering if someone could please help me with the following. I have 'Table' worksheet with sales figures and I'm trying to work out how to make a macro go through a list on the 'Lookup' worksheet, find and replace the values in the 'Table' worksheet. For example, to search "Product 2" in column A of 'Table' worksheet and replace with "DELETED Product 2" (data from the 'Lookup' worksheet). This would continue until all values have been checked and replaced. Also on the 'Table' worksheet, a pr
This question generated 14 answers. To proceed to the answers, click here.