+ Reply to Thread
Results 1 to 4 of 4

Select specific rows beginning with same word from multiple sheets and copy to new sheet

  1. #1
    Registered User
    Join Date
    09-06-2011
    Location
    Paris
    MS-Off Ver
    Excel 2003
    Posts
    23

    Select specific rows beginning with same word from multiple sheets and copy to new sheet

    I am looking for code please to perform the following. I have a number of spreadsheets with the same layout but varying numbers of rows. One row always begins with the same word, and another row always begins with a different word. I'd like to copy both those rows from each sheet, keeping them together, and put them into a new sheet.

    Another way of expressing this:

    worksheet 1

    Name -------
    Data
    Data
    Data
    Total


    worksheet 2

    Name -------
    Data
    Total

    The product in a new worksheet would be:

    Name
    Total
    Name
    Total.

    I would be very grateful for help.

  2. #2
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: Select specific rows beginning with same word from multiple sheets and copy to new she

    Try something like the code below. Make sure you have a sheet called "Result".

    Please Login or Register  to view this content.
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown

  3. #3
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: Select specific rows beginning with same word from multiple sheets and copy to new she

    Duplicated post when board had issues
    Last edited by WasWodge; 06-22-2014 at 06:43 AM.

  4. #4
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: Select specific rows beginning with same word from multiple sheets and copy to new she

    Unashamed bump because post #2 didn't register as a post.
    Please see post #2.

+ 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] I need to search for a word on multiple sheets and copy the entire row to a new sheet
    By jkm750 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-26-2013, 12:13 AM
  2. How to select rows either beginning with a 'BOLD' word or a capital E?
    By ahrimaniac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-15-2013, 11:45 AM
  3. Combineing specific rows from multiple sheets to one sheet
    By Muttly in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 02-14-2013, 10:17 AM
  4. VBA help - copy from multiple sheets beginning with "sheet"
    By mdelon1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-26-2012, 02:16 PM
  5. copy select rows on 2 sheets to a 3rd sheet
    By thedeacon in forum Excel General
    Replies: 2
    Last Post: 03-26-2009, 02: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