+ Reply to Thread
Results 1 to 5 of 5

Help with copying partial rows to another worksheet when text indicates

  1. #1
    Registered User
    Join Date
    05-27-2014
    Posts
    2

    Help with copying partial rows to another worksheet when text indicates

    Hi,

    I need information from the Open Searches worksheet to copy over to the Candidate Slate – Closed worksheet when the information in Open Searches worksheet, column N says “Closed.”

    I need columns B through G to copy over to the Candidate Slate – Closed worksheet. Does that make sense? I've tried "borrowing" others' macros and formulas, but alas, I am too Excel ignorant to make it work. Please help?!

    Thanks!
    ChristinaMaster Activity Report_May 2014 TEST.xlsmMaster Activity Report_May 2014 TEST.xlsm

  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,811

    Re: Help with copying partial rows to another worksheet when text indicates

    Try this:

    Please Login or Register  to view this content.
    Note that you must include the period after Closed or the macro will fail.
    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 Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Help with copying partial rows to another worksheet when text indicates

    you could also use below formula in candidate slate closed worksheet.
    in A6 copy paste below then hold control and shift together and then hit enter
    =IFERROR(INDEX('Open Searches'!B$2:B$34,SMALL(IF(TRIM('Open Searches'!$N$2:$N$34)="closed.",ROW($N$2:$N$34)-MIN(ROW($N$2:$N$34))+1),ROWS($A$1:A1))),"")

    drag down and drag to right up to column F
    change the references as per your actual data
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  4. #4
    Registered User
    Join Date
    05-27-2014
    Posts
    2

    Re: Help with copying partial rows to another worksheet when text indicates

    Perfect. I appreciate your quick response. I can now move along after spending 2 hours trying to figure this out on my own. Thank you!

  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,811

    Re: Help with copying partial rows to another worksheet when text indicates

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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] Match partial text when partial text is not exact
    By NamiSama in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-21-2014, 07:18 PM
  2. [SOLVED] Copying partial rows based on contents of one cell.
    By TomRet in forum Excel Programming / VBA / Macros
    Replies: 42
    Last Post: 01-02-2014, 02:48 PM
  3. [SOLVED] Copying value in A1 based on partial text in H1
    By Groovicles in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-01-2013, 12:19 PM
  4. Macro to delete rows based on partial text
    By rossi_69 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-09-2009, 06:25 PM
  5. Deleting rows based upon partial cell text
    By mjwillyone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2008, 10:29 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