Hi Everyone,
I am new to writing macros.
I am trying to figure out a macro to cut a specific cell and the next 9 cells to a new row.
Tried the macro recorder but don't know how to get it to continue to the end of the row until there is no more data.
The scenario is a sheet with 1 row that contains hundreds of columns with data.
In that row, there is a "common text" in a cell and then 9 more cells of data, and this pattern reoccurs.
The worksheet before:
<tbody>
</tbody>
In a new Worksheet after macro:
<tbody>
</tbody>
Any help would be appreciated!
Thanks,
Stan
I am new to writing macros.
I am trying to figure out a macro to cut a specific cell and the next 9 cells to a new row.
Tried the macro recorder but don't know how to get it to continue to the end of the row until there is no more data.
The scenario is a sheet with 1 row that contains hundreds of columns with data.
In that row, there is a "common text" in a cell and then 9 more cells of data, and this pattern reoccurs.
The worksheet before:
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
1 | text | data1 | data2 | data3 | data4 | data5 | data6 | data7 | data8 | data9 | text | data10 | data11 | data12 |
<tbody>
</tbody>
In a new Worksheet after macro:
A | B | C | D | E | F | G | H | I | J | |
1 | text | data1 | data2 | data3 | data4 | data5 | data6 | data7 | data8 | data9 |
2 | text | data10 | data11 | data12 | data13 | data14 | data15 | data16 | data17 | data18 |
3 | text | data19 | data20 | data21 | data22 | data23 | data24 | data25 | data26 | data27 |
<tbody>
</tbody>
Any help would be appreciated!
Thanks,
Stan