Need help to search for matching data and replace the data

Jack

New member
Joined
Mar 1, 2013
Messages
4
Reaction score
0
Points
0
I have workbook with a number of spreadsheets with data in them that I need to search for matching data and replace the data; I would like to use a macro if possible.

I have a worksheet called BOM LINE and need to search column C for any number ending in X, XX or XXX then I need to find the number from the BOM LINE sheet in the ROUTE LINE sheet “this number will not have the X’s on the number and there will be multiples in the ROUTE LINE sheet the unique identifier will be the Operation no. column B on the ROUTE LINE sheet this number will be the same on the BOM LINE sheet column E after this has been done then I need to look at the worksheet Sheet2 and find the X number in column A and then copy the data in column B to column C of the worksheet BOM LINE

Thanks in advance for any help
 

Attachments

  • BOM Sample.xlsx
    130.7 KB · Views: 13

Jack

New member
Joined
Mar 1, 2013
Messages
4
Reaction score
0
Points
0
Any help on this from all you experts,

Please
 
Top