+ Reply to Thread
Results 1 to 5 of 5

How to find data in sheet1 matches matches with archive dta base and update it on sheet3

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    EXCEL 2016
    Posts
    1,045

    How to find data in sheet1 matches matches with archive dta base and update it on sheet3

    Hi

    Have two workbooks one is PO and the other master archive database .

    Is there a formula or macro so that I can know what item no ref list in the po exist in master archive .

    If so then insert it in checkup list sheet. with whole row data of of archive master and highlight the item no row in po sheet

    copy the whole row in master achive database to check up list.
    thanks
    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: How to find data in sheet1 matches matches with archive dta base and update it on shee

    Hi Jean,

    See whether this is what you want:

    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
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    EXCEL 2016
    Posts
    1,045

    Re: How to find data in sheet1 matches matches with archive dta base and update it on shee

    Hi xladept

    Tested works marvellously.

    Thank you a lot, it saves me from a daily difficult task.

    JEAN

  4. #4
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    EXCEL 2016
    Posts
    1,045

    Re: How to find data in sheet1 matches matches with archive dta base and update it on shee

    Hi xladept

    Tested works marvellously.

    Thank you a lot, it saves me from a daily difficult task.

    JEAN

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

    Re: How to find data in sheet1 matches matches with archive dta base and update it on shee

    You're welcome and thanks for the rep!

+ 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. Comparing Data between sheets to find matches and no matches
    By tysont in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-26-2015, 03:07 PM
  2. [SOLVED] Check if data in Sheet1 matches with Sheet2 and then update sheet1
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2014, 01:39 PM
  3. [SOLVED] Need help pulling information from Sheet2 if it matches criteria from Sheet3.
    By Teblol in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-14-2014, 03:26 PM
  4. Replies: 5
    Last Post: 08-29-2012, 03:08 AM
  5. Replies: 0
    Last Post: 08-11-2012, 03:25 PM

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