suntreemom
New Member
- Joined
- Dec 18, 2013
- Messages
- 3
Hi. I am not really a coder and this is new to me but I have an extremely large spreadsheet I need to disect into a seperate workbook for each set of data. While browsing on this forum I saw many references for splitting data, but it always split it due to a certain value in a column. My column the value is always unique, but the end of the section I need to split the data ends with
<tbody>
</tbody> <colgroup> <col></colgroup>For instance, I have 4 columns with no headers. Each value is different. It is set up like this:
<tbody></tbody>
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>I need to read the value in each Column A cell (ZAU6101G), this will become the title of my new 'workbook' after being split out. I take all the rows beneath that leading column A cell, until I find a row with >end, and copy over to the new 'workbook' and save the new workbook with the cell A title.
From the table above it would split into three worksheets- titled ZAU6101G, ZAU6101H, and ZAU6101I. The first workshhet would look like this:
<tbody>
</tbody>The second:
<tbody>
</tbody>The third:
<tbody>
</tbody>I have over 4,000 rows of data to split. Is this possible? Will excel only provide this functionality for so many rows, etc?
Thank you to anyone who can help!! I do not even know how to set up a VB script in excel so please explain like a book for dummies
Suntreemom
>end |
<tbody>
</tbody> <colgroup> <col></colgroup>
<tbody></tbody>
ZAU6101G | grp=ZAU61 | altmin=986 | altmax=987 |
43.716667 | 272.116667 | node=CG31 | |
43.716667 | 272.183333 | node=CG32 | |
43.783333 | 272.183333 | node=CG22 | |
43.783333 | 272.116667 | node=CG21 | |
>end | |||
ZAU6101H | grp=ZAU61 | altmin=988 | altmax=989 |
43.716667 | 272.116667 | node=CG31 | |
43.716667 | 272.183333 | node=CG32 | |
43.783333 | 272.183333 | node=CG22 | |
43.783333 | 272.116667 | node=CG21 | |
>end | |||
ZAU6101I | grp=ZAU61 | altmin=990 | altmax=991 |
43.716667 | 272.116667 | node=CG31 | |
43.716667 | 272.183333 | node=CG32 | |
43.783333 | 272.183333 | node=CG22 | |
43.783333 | 272.116667 | node=CG21 | |
>end |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
From the table above it would split into three worksheets- titled ZAU6101G, ZAU6101H, and ZAU6101I. The first workshhet would look like this:
ZAU6101G | grp=ZAU61 | altmin=986 | altmax=987 |
43.716667 | 272.116667 | node=CG31 | |
43.716667 | 272.183333 | node=CG32 | |
43.783333 | 272.183333 | node=CG22 | |
43.783333 | 272.116667 | node=CG21 | |
>end |
<tbody>
</tbody>
ZAU6101H | grp=ZAU61 | altmin=988 | altmax=989 |
43.716667 | 272.116667 | node=CG31 | |
43.716667 | 272.183333 | node=CG32 | |
43.783333 | 272.183333 | node=CG22 | |
43.783333 | 272.116667 | node=CG21 | |
>end |
<tbody>
</tbody>
ZAU6101I | grp=ZAU61 | altmin=990 | altmax=991 |
43.716667 | 272.116667 | node=CG31 | |
43.716667 | 272.183333 | node=CG32 | |
43.783333 | 272.183333 | node=CG22 | |
43.783333 | 272.116667 | node=CG21 | |
>end |
<tbody>
</tbody>
Thank you to anyone who can help!! I do not even know how to set up a VB script in excel so please explain like a book for dummies
Suntreemom