+ Reply to Thread
Results 1 to 4 of 4

Update only records that are found

  1. #1
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Davenport, Iowa
    MS-Off Ver
    Excel 365
    Posts
    206

    Update only records that are found

    Hi,

    I have a workbook where users dump in data into a sheet called Query. I need help with a script that will match the PO and Item number on the Existing Orders sheet, and update only those records, and leave everything else as it is.
    Attached Files Attached Files

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Update only records that are found

    Try this:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Davenport, Iowa
    MS-Off Ver
    Excel 365
    Posts
    206

    Re: Update only records that are found

    Worked like a charm, quick, and accurate. Thank you!

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Update only records that are found

    You're welcome!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] rename & skip records if file not found
    By sanjuss2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2018, 05:41 AM
  2. Replies: 2
    Last Post: 12-20-2013, 01:09 PM
  3. [SOLVED] need to be able to update records with button click and delete records sample included
    By unreal11 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2013, 11:45 PM
  4. [SOLVED] No Records Found (autofilter)
    By bmcgrath in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2012, 02:23 PM
  5. My formula is pulling all multiple records except the first one found
    By jshumberger25 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-24-2012, 03:36 PM
  6. [SOLVED] Counter for records found during Find
    By excelnut1954 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-21-2006, 07:25 PM
  7. [SOLVED] how do I display filtered records found
    By Pat in forum Excel General
    Replies: 1
    Last Post: 12-29-2005, 10:40 AM

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