I have a workbook with a three spreadsheets with data in them that I need to search for matching data and replace the data on one of the sheets; I would like to use a macro if possible.
The worksheet called BOM LINE column C has to be search for any number ending in X, XX or XXX then I need to find the corresponding number from the BOM LINE column A in the sheet ROUTE LINE sheet in column A there will be multiples of this number in the ROUTE LINE sheet column A the unique identifier will be column B on the ROUTE LINE sheet this number will be the same on the BOM LINE sheet column E next I need to look in the sheet BOM LINE column C and find the same number in the worksheet XData column A and then copy the data in column B to column C of the worksheet ROUTE LINE Sheet. An example of what I am looking for is in the attached.
Bookmarks