I have a spreadsheet of product information in Sheet 1. Each product has a unique ID code. However, I need to update all occurenced of the unique product ID with a new code that has been generated for each one. So, I have a lookup table that lists 'old product ID' and 'new product id' in Sheet 2
Is it possible with VB to loop through the lookup list in Sheet2 and replace all occurences in the sheet 1?
E.g. Sheet 1
Product ID | Name | Category | Related Product | 0001 t-shirt 10 005, 987 0002 shorts 12 009, 004 Sheet 2 old product ID | new product ID 0001 TEE_1 0002 SHRT_1 009 SOCK_1
So you will see, that where a value is found in column ' old product ID' it needs to be replaced with the value in column 'new product ID'
Thanks for any advice!