Find & Replace Data Between 2 Sheets

  • Re: Find And Replace Old Data With New Data


    Quote from Reafidy

    Thats lovely, how about a question?


    What I want to do is to replace the old data in sheet 1 with the data from sheet2


    Here is a code which almost does what I want but somehow need to replace data in sheet1 column b with data from sheet2.


  • Re: Find And Replace Old Data With New Data


    Either you are leaving out information that is vital to your question, or you are making this far too complicated. Why not just copy Sheet2 and paste over Sheet1?

  • Re: Find And Replace Old Data With New Data


    Sheet1 is the master inventory and I am using sheet2 for new activity.


    Sheet2 may only have 20 items in it and not in the same order as sheet1.


    what I hope to do is use a hand barcode scanner for the item number. These are on businss cards produced from Excel.


    Since most quanities withdrawals are less than ten, I would have a single sheet for the most popular WD quanities to point the hand scanner to.

  • Re: Find And Replace Old Data With New Data


    Try this:

    Code
    For Each cell In rng2
    On Error Resume Next
    rng1.Find(cell).Offset(0, 1) = cell.Offset(0, 1)
    If Err.Number <> 0 Then MsgBox cell.Value & " was not found in master list"
    On Error GoTo 0
    Next cell

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!