+ Reply to Thread
Results 1 to 3 of 3

Search for a term, copy a block of cells to another worksheet, continue search

  1. #1
    Registered User
    Join Date
    02-06-2014
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2010
    Posts
    48

    Search for a term, copy a block of cells to another worksheet, continue search

    I need a function that will search through an array of data on one worksheet named "2010-2012", look for a matching term (say "apple"), then where it finds that term, select and copy all the cells in a range around it (from the row with "apple" down 5 rows and 7 columns), then paste that array to the worksheet named "Sheet1", and iteratively keep doing this until all the data has been reviewed and all matches copied to "Sheet1" without over writing itself.

    What I have (that doesn't work) is:

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,910

    Re: Search for a term, copy a block of cells to another worksheet, continue search

    Try it this way: not sure what you meant by down 5 rows so I used 6 rows as the size for copying (down 5 more rows...) Anyways, give it a whirl.

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    02-06-2014
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: Search for a term, copy a block of cells to another worksheet, continue search

    Worked like a charm!! Now to study how you did it, so I can do this myself in the future.

    Thank so much!!

+ 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: 2
    Last Post: 07-01-2013, 10:00 PM
  2. [SOLVED] When a search term appears in column I, copy the value from column H to a new cell.
    By ShallowJamm in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-28-2012, 06:36 PM
  3. Search for term in multiple cells
    By Snowtoad in forum Excel General
    Replies: 1
    Last Post: 08-13-2010, 02:25 AM
  4. Search up/down from n'th term and retrieve value if minimum difference
    By scope951 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-26-2010, 07:16 AM
  5. Replies: 1
    Last Post: 03-04-2010, 10:08 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