Hi
I have a worksheet containing several small datasets, example below:
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
So that's how my worksheet looks like. I would like it to be split into multiple (three according to this example) worksheets. I thought it could be done by splitting if a certain column name is found, for example if vba encounters cell with a value "Claim_number", it transfers column names and below rows to a different worksheet. Or it could be done by splitting if there's a blank row between these small datasets. I just want something like that:
Worksheet1:
<tbody>
</tbody>
Worksheet2:
<tbody>
</tbody>
Worksheet3:
<tbody>
</tbody>
Any ideas how to do that?
Thank you in advance!
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody></body>
I have a worksheet containing several small datasets, example below:
Claim_number | Model | Name | Value |
zyx | a | b | 1 |
pol | c | d | 2 |
<tbody>
</tbody>
Claim_number | Model | Address | Value |
qwe | e | ab | 1 |
asd | f | cd | 2 |
zzd | g | ef | 3 |
<tbody>
</tbody>
Claim_number | Model | Address | Value |
oko | h | gh | 1 |
klo | i | ij | 2 |
<tbody>
</tbody>
So that's how my worksheet looks like. I would like it to be split into multiple (three according to this example) worksheets. I thought it could be done by splitting if a certain column name is found, for example if vba encounters cell with a value "Claim_number", it transfers column names and below rows to a different worksheet. Or it could be done by splitting if there's a blank row between these small datasets. I just want something like that:
Worksheet1:
Claim_number | Model | Name | Value |
zyx | a | b | 1 |
pol | c | d | 2 |
<tbody>
</tbody>
Worksheet2:
Claim_number | Model | Address | Value |
qwe | e | ab | 1 |
asd | f | cd | 2 |
zzd | g | ef | 3 |
<tbody>
</tbody>
Worksheet3:
Claim_number | Model | Address | Value |
oko | h | gh | 1 |
klo | i | ij | 2 |
<tbody>
</tbody>
Any ideas how to do that?
Thank you in advance!
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
Claim_number | Model | Address | Value |
qwe | e | ab | 1 |
asd | f | cd | 2 |
zzd | g | ef | 3 |
<tbody>
</tbody>