spill-the-beans
Board Regular
- Joined
- Feb 7, 2013
- Messages
- 52
Hi
My workbook has 2 sheets - one named Data, one named Results.
What I need to happen is, excel should look in column J in the Data worksheet. When it finds the next non empty cell, it should copy across the row values for columns J to AG of the Data worksheet into columns A to X of the Results worksheet.
The Results copied rows should be one below the other, but in the Data, the rows to copy are spaced out. The information in A:I of Data should not be copied across to Results.
So..
Data worksheet
<tbody>
</tbody>
Results worksheet
<tbody>
</tbody>
Help would be very much appreciated!
My workbook has 2 sheets - one named Data, one named Results.
What I need to happen is, excel should look in column J in the Data worksheet. When it finds the next non empty cell, it should copy across the row values for columns J to AG of the Data worksheet into columns A to X of the Results worksheet.
The Results copied rows should be one below the other, but in the Data, the rows to copy are spaced out. The information in A:I of Data should not be copied across to Results.
So..
Data worksheet
A:I | J:AG | |
1 | unneeded information | needed data set1 |
2 | unneeded information | |
3 | unneeded information | |
4 | unneeded information | needed data set 2 |
<tbody>
</tbody>
Results worksheet
A:X | |
1 | needed data set 1 |
2 | needed data set 2 |
<tbody>
</tbody>
Help would be very much appreciated!