+ Reply to Thread
Results 1 to 4 of 4

Finding and reorganizing cells in VBA

  1. #1
    Registered User
    Join Date
    10-16-2014
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2011 Mac
    Posts
    13

    Finding and reorganizing cells in VBA

    Hi,

    I have attached an example sheet with input and output for reference.

    I have been scouring the internet but can't seem to figure out how write the right VBA to:

    1. Search for the first instance of the phrase "My name is" and copy that whole cell and paste it in a cell that is in the same row as the first number.

    2. Similarly, search for "This survey took place" and copy the following date (the dates differ in length sometimes), and paste that in a cell that is in the same row as the first number.

    For the first part, this is what I have (incorrectly) come up with so far:

    Please Login or Register  to view this content.

    Any help would be greatly appreciated! Thanks!

    Example Input and Output.xlsx

  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: Finding and reorganizing cells in VBA

    Try this:

    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
    Registered User
    Join Date
    10-16-2014
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2011 Mac
    Posts
    13

    Re: Finding and reorganizing cells in VBA

    Works perfectly, thanks!

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

    Re: Finding and reorganizing cells in VBA

    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. Reorganizing data into blank cells a variable number of columns to the right
    By zookeepertx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-15-2014, 04:45 PM
  2. Reorganizing a report
    By Sech1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-03-2014, 04:32 AM
  3. Extracting and reorganizing values in cells
    By Melvinrobb in forum Excel General
    Replies: 1
    Last Post: 09-25-2012, 08:46 PM
  4. Replies: 3
    Last Post: 03-02-2007, 07:13 AM
  5. Skipping cells while reorganizing data
    By vertblancrouge in forum Excel General
    Replies: 0
    Last Post: 04-25-2005, 03:06 PM

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