+ Reply to Thread
Results 1 to 2 of 2

Find, copy and paste into a new page

  1. #1
    Registered User
    Join Date
    05-07-2012
    Location
    Mclean, VA
    MS-Off Ver
    Excel 2007
    Posts
    10

    Find, copy and paste into a new page

    Hello,

    I'm trying to create a macro that will find a certain word, let's say "test" and then it will copy all the text between 2 certain points(***** and *****) in the doc. Then it will paste it into a new doc called "test" and number each one. Below is an example.

    *****
    hello
    goodbye
    test
    nice extremely cold
    *****
    Not all instances are this simple. Some only have 5 lines of text between the "*****", as the example above, ans some have up to 60 lines of text.

    Also, if possible I would like each instance to be pasted into a new page within the same doc after the first instance is found. It would also give a total on the first line of the doc.

    Thanks in advance.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Find, copy and paste into a new page

    Cross-posted at: http://www.msofficeforums.com/word-v...-new-page.html
    For cross-posting etiquette, please read FORUM RULE 8: http://www.excelforum.com/forum-rule...rum-rules.html
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

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