Results 1 to 3 of 3

Thread: Need help to search for matching data and replace the data

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Question Need help to search for matching data and replace the data

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •