Results 1 to 3 of 3

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Any help on this from all you experts,

    Please

  3. #3

    Unhappy

    Quote Originally Posted by Jack View Post
    Any help on this from all you experts,

    Please
    Need help finishing the code, thanks
    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
  •