+ Reply to Thread
Results 1 to 7 of 7

Transfer Every Matched Entry's Entire Row to a Different Sheet

  1. #1
    Registered User
    Join Date
    08-28-2014
    Location
    NJ
    MS-Off Ver
    2010
    Posts
    50

    Transfer Every Matched Entry's Entire Row to a Different Sheet

    I want to take the horse (Column T) from sheet 'This week', match it to horses in column T in sheet 'All' and then paste every instance/match from sheet 'ALL' into 'Extracted.'

    Note: this list is huge. There are over 30,000 entries in sheet 'ALL'. Usually in sheet 'ThisWeek' there is a thousand.


    the code below does what I need it to other than two things.

    1. It does not past the entire row. I need it to go all the way up to and including column JF.

    2. It does not paste every instance of the horse (Column T) in sheet 'This Week' from sheet 'All'.

    3. I know I said two. But... I don't want it to resize the columns.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Transfer Every Matched Entry's Entire Row to a Different Sheet

    Please stop Pm, I can see your post here. This is not paid this section.
    I suggested to you not to have a complete blank column. It is really bad spread sheet design to have a complete blank column then add more data after it. I have changed the code to go to last column.
    The code looks at sheet this week. That was what APO did and you were happy with it. You have now changed the request to other sheet.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-28-2014
    Location
    NJ
    MS-Off Ver
    2010
    Posts
    50

    Re: Transfer Every Matched Entry's Entire Row to a Different Sheet

    I meant no offense by the private message. Forgive me.

  4. #4
    Registered User
    Join Date
    08-28-2014
    Location
    NJ
    MS-Off Ver
    2010
    Posts
    50

    Re: Transfer Every Matched Entry's Entire Row to a Different Sheet

    I guess I didn't explain it well enough. In this new workbook, every entry from sheet "ALL" should appear in sheet "Extracted." If the horse matches from "ThisWeek" into "ALL", I'd like every instance of it from "ALL" to paste into "Extracted."

    Thank you for your time, truly. I do hope that you can pardon my ignorance to protocol and to VBA.

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Transfer Every Matched Entry's Entire Row to a Different Sheet

    Another approach:

    Please Login or Register  to view this content.

  6. #6
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Transfer Every Matched Entry's Entire Row to a Different Sheet

    Okay!
    I have amended the code.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    08-28-2014
    Location
    NJ
    MS-Off Ver
    2010
    Posts
    50

    Re: Transfer Every Matched Entry's Entire Row to a Different Sheet

    AB, that seems to do it. Thank you so very much. And my deepest apologies for being a pain in the a**. If anything goes awry, I shall most certainly post again! Worked just fine and very quickly. Again, thank you.

+ 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] Code to transfer latest entry from sheet 'Account' to sheet 'Summary' automatically
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-30-2014, 08:56 PM
  2. [SOLVED] Copy & paste entire row to different sheet based on cell entry
    By XxCMoneyxX in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-14-2013, 07:52 PM
  3. [SOLVED] [How-to] ask marco to find, cut, paste entire row to new sheet if matched?
    By hark in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 11-15-2012, 01:55 AM
  4. VBA Script for Transfer Data from Entry Sheet to Master by Using Command Button
    By sgolwalkar4ever in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2012, 07:24 AM
  5. MACRO Transfer entire row based on a table in a third sheet/tab
    By eastydie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-31-2011, 04:48 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