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
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