+ Reply to Thread
Results 1 to 3 of 3

VBA to Find Specific Text, then Copy range to next open cell under specific text

  1. #1
    Registered User
    Join Date
    03-02-2006
    Location
    USA
    MS-Off Ver
    O365 PC, Version 2207, 64bit
    Posts
    63

    VBA to Find Specific Text, then Copy range to next open cell under specific text

    I'm looking to copy specific text from R5:AC5 to the first blank cell in column B after matching the text in R5 with text in column B

    R5=Apples

    B1= "Apples"
    B2= Random alphanumeric
    B3= Random alphanumeric
    B4= Blank
    B5= Random alphanumeric

    R5:AC5- various alphanumeric text.
    This would be copied into B4 since it is blank.


    Thanks!
    Last edited by JBeaucaire; 02-23-2015 at 07:11 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: VBA to Find Specific Text, then Copy range to next open cell under specific text

    Attaching a sample workbook enables others to work on your problem:

    To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Registered User
    Join Date
    03-02-2006
    Location
    USA
    MS-Off Ver
    O365 PC, Version 2207, 64bit
    Posts
    63

    Re: VBA to Find Specific Text, then Copy range to next open cell under specific text

    I was able to hack together a solution:

    Please Login or Register  to view this content.

+ 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. Replies: 3
    Last Post: 10-31-2013, 03:41 PM
  2. [SOLVED] Formula to find a specific text within a range and return the value in the next cell
    By 00pumpkin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-19-2013, 02:11 PM
  3. Replies: 2
    Last Post: 08-05-2013, 07:32 PM
  4. Macro to copy specific line from text file and paste into specific cell in excel
    By keeneye in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 10:35 AM
  5. Find the specific text and copy and paste in another cell only if true.
    By SHARIB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2012, 03:14 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