+ Reply to Thread
Results 1 to 1 of 1

Find->copy a fixed no. of cells from the found cell->paste to a new sheet or file->repeat

  1. #1
    Registered User
    Join Date
    08-12-2013
    Location
    pleasanton, CA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Find->copy a fixed no. of cells from the found cell->paste to a new sheet or file->repeat

    My title says it all. Below is an excerpt of my data file. Imagine this block of data is scattered all over this really large file with no fixed locations.

    What I need to do is:
    1. Search for the words, "resistance test"
    2. Copy a block of cells starting from the cell that contains the word "Column" then end at the location where R31 and T4 meet. Other words, start at "Column", count 6 to the right and count downwards 5. This cell happens to have -0.004 in it.
    3. Paste this table to a file or another excel sheet.
    4. Repeat.

    Resistance Test
    Data
    Parameters
    Column R25 R22 R21 R30 R23 R31 TXROE
    T0 -0.005 0.009 -0.003 0.001 -0.005 -0.000 0.001
    T1 -0.001 -0.007 0.003 0.006 0.008 0.001 0.004
    T2 0.000 0.009 -0.005 -0.001 -0.001 0.006 0.005
    T3 -0.006 -0.001 0.000 0.001 -0.009 -0.005 0.001
    T4 0.004 -0.006 -0.001 0.000 0.009 -0.004 -0.001
    RXROE -0.006 0.007 -0.013 0.002 -0.065 -0.044 0.011

    Can it be done? Thanks in advance.
    Last edited by Excel4Dummy; 08-12-2013 at 09:53 AM.

+ 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] To Find every instance of TEXT copy, repeat until no Find found
    By DadaaP in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2013, 02:15 PM
  2. [SOLVED] Find value in a cell in different sheets and copy and paste other cells to another sheet
    By the-hawk in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-04-2013, 03:36 AM
  3. [SOLVED] Find cell in Range and If found then copy to next sheet
    By Sachy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-20-2013, 10:56 AM
  4. Code to write formula in 2 cells, copy, paste values, repeat next row until end of sheet
    By Oly Steel Man in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2013, 11:13 AM
  5. [SOLVED] find cell then copy multiple cells from that found cell
    By bob33 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-02-2013, 11:42 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