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.
Bookmarks