Hello all,
I'm rather new here, so apologies if this is a rather silly question. I did search through previous posts but cant find anything that's similar to what I'm trying to do.
I have 2 sheets in a workbook
Sheet 1 - Product - has 2 columns. column A contains a Product Code and Column B contains Product Name (400 rows)
Sheet 2 - Customer purchases - contains 3 columns. Column A contains customer id, column B contains customer name, and Column C contains Product Name.
What I'm wanting to do is to replace the product name in Sheet B with the related product code in Sheet 1.
So is there a macro that could recursivey use the data from sheet 1 to replace the data in sheet 2? So it would go through each row in sheet one use the data to do a find replace in sheet 2
I would be most grateful for any help provided.
Cheers
Michael
Bookmarks