Results 1 to 7 of 7

Find 2 words and copy and paste everything in between

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    03-03-2009
    Location
    UK
    MS-Off Ver
    MS365 Subscription Excel for Mac
    Posts
    1,017

    Question Find 2 words and copy and paste everything in between

    I want a macro to search column A for the word Starting Time. I then want it to look in Col A for the word Ending Time. I then want to copy every cell in Col A between those words and paste it into sheet2 A1. After this, I want it to repeat the above except look for the 2nd time that Starting Time appears and the 2nd time that Ending Time appears and copy everything in between and paste into sheet2 B1. Thanks in advance!

    The word Ending Time will always occur after Starting Time
    Last edited by ScabbyDog; 03-17-2013 at 03:50 PM.

Thread Information

Users Browsing this Thread

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

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