+ Reply to Thread
Results 1 to 8 of 8

Search and replace data.

  1. #1
    Registered User
    Join Date
    02-27-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Question Search and replace data.

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

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Search and replace data.

    Hi.

    In BOM LINE sheet u have filters assigned. Do u have data from 2 or from row 171?
    Click *, if my suggestion helps you. Have a good day!!

  3. #3
    Registered User
    Join Date
    02-27-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Search and replace data.

    Yes there is data and the filters can be turned off
    i just put the filters on so you can see that data i need

  4. #4
    Valued Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    353

    Re: Search and replace data.

    I solved it with VBA
    It was rather complicated.
    This simple code does a 1 by 1 search so it takes a few seconds to finish.
    Let me know if this is want you wanted.
    Attached Files Attached Files
    Kind regards,
    Piet Bom

  5. #5
    Registered User
    Join Date
    02-27-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Search and replace data.

    Quote Originally Posted by PietBom View Post
    I solved it with VBA
    It was rather complicated.
    This simple code does a 1 by 1 search so it takes a few seconds to finish.
    Let me know if this is want you wanted.
    Seems to work will test on Monday, Thanks for the help

  6. #6
    Registered User
    Join Date
    03-03-2013
    Location
    bccb
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: Search and replace data.

    dddddddddddddddddddddddddddddd

  7. #7
    Registered User
    Join Date
    03-03-2013
    Location
    bccb
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: Search and replace data.

    I am sorry for writing here, but I seem to be unable to post a question, could you help me with it or with making it a separate thread?

    I would like to make a kind of a dictionary to help my studies. On the first worksheet I would like to have cells A-word, B-definition, C-name of group of synonyms it belongs to, D-synonyms. On the second sheet I would like to have columns A - name of the group and B - the synonyms. I would like to choose the group name on the first page from a drop down list and I want to have a formula for cell B on Sheet2, which would choose only the relevant cells from Sheet1 column A and show them there. If the SUMIF function worked with text, the formula would have looked like this =SUMIF(Sheet1!C1:C1000, "Animals", Sheet1!A1:A1000). I would be very grateful if anyone could advise me on how to do it with text. I think the formula that works with text is called "concatenate", but I can't figure out a way to use it for this purpose

  8. #8
    Valued Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    353

    Re: Search and replace data.

    @bccb,
    When you go to the wanted forum e.g.: Excel Programming / VBA / Macro's
    There is a button (top-left side): + Post New Thread

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1