+ Reply to Thread
Results 1 to 5 of 5

If Value in Sheet 1 Exists in Another Workbook/Worksheet, Copy/Paste Entire Row

  1. #1
    Forum Contributor
    Join Date
    05-24-2012
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2007
    Posts
    113

    If Value in Sheet 1 Exists in Another Workbook/Worksheet, Copy/Paste Entire Row

    I have a sheet named Tracking File and the value that I want to use for reference is contained in Column A, let's call Column A, order_id.

    The Tracking File workbook only contains the order_id column, but I need to be able to find each of these order_id values in other sheets (or workbooks in the same folder), and copy over the entire rows which include additional values/columns in addition to the order_id.

    I don't mind if it copies over existing rows in the Tracking File, or if it simply adds the new rows to the bottom of this sheet.

    Is there an easy way to do this, because the order_id's are spread across multiple other sheets right now, which is why i said i can bring all of those sheets into the same workbook, if that makes things easier?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: If Value in Sheet 1 Exists in Another Workbook/Worksheet, Copy/Paste Entire Row

    How many sheets and workbooks are involved? Will the order_id that you are searching for appear in more than one worksheet/workbook?
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    05-24-2012
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2007
    Posts
    113

    Re: If Value in Sheet 1 Exists in Another Workbook/Worksheet, Copy/Paste Entire Row

    To answer your first question:
    There are perhaps a total of 26 workbooks, each consisting of just a single sheet with anywhere from 10-200 rows.
    This is why I was wondering it would make things easier if I just consolidate all of the workbooks into a single workbook that just consists of multiple sheets?

    To answer your second question:
    The order_id will not appear in more than one worksheet/workbook, apart from the fact that just the Tracking File contains it, and just one of the other sheets/books.

  4. #4
    Forum Contributor
    Join Date
    05-24-2012
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2007
    Posts
    113

    Re: If Value in Sheet 1 Exists in Another Workbook/Worksheet, Copy/Paste Entire Row

    Would it help if I attached a few of the sheets/workbooks?

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: If Value in Sheet 1 Exists in Another Workbook/Worksheet, Copy/Paste Entire Row

    Given that there are 26 workbooks, if you can consolidate them, then it would be easier to extract the information using a Vlookup. Look here for an explanation of that function.

    http://www.techonthenet.com/excel/formulas/vlookup.php

    Alan

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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