I imported a very large flat file dump (187K line) and want to move ranges of cells to a new worksheet if a cell in the range contains a specific sub-string. These strings can appear multiple times in the file dump as well as multiple times within a range/block. So whenever the string appears in a block, move it to the next empty column in the new WS.
The range/blocks can vary from a dozen lines to over 1000. They all begin with two cells of 10 "s" each, followed by a blank cell. The first cell in each range begins with a specific sub-string (ACO: ) and has a sub-string I need to search: either a 7 digit number, or a username. Ideally, I'd like to spawn a new WS named with the sub-string I'm searching by, and moving the blocks to separate columns in that WS.
Even more ideally, if it can run through a named list of values and move the ranges/blocks to new WS's...with each block in a separate column (not asking for a home run, but if anyone is feeling the challenge).
Sample data set:
ColA
<tbody>
</tbody>
The range/blocks can vary from a dozen lines to over 1000. They all begin with two cells of 10 "s" each, followed by a blank cell. The first cell in each range begins with a specific sub-string (ACO: ) and has a sub-string I need to search: either a 7 digit number, or a username. Ideally, I'd like to spawn a new WS named with the sub-string I'm searching by, and moving the blocks to separate columns in that WS.
Even more ideally, if it can run through a named list of values and move the ranges/blocks to new WS's...with each block in a separate column (not asking for a home run, but if anyone is feeling the challenge).
Sample data set:
ColA
| ssssssssss |
| ssssssssss |
| ACO: web.site.com: 1234567 - user.name1 |
| DataPoint1 |
| DataPoint2 |
| DataPoint3 |
| DataPoint4 |
| DataPoint5 |
| DataPoint11 |
| DataPoint12 |
| DataPoint13 |
| DataPoint16 |
| DataPoint17 |
| ssssssssss |
| ssssssssss |
| ACO: web2.site2.com: 1234567 - user.name1 |
| DataPoint1 |
| DataPoint2 |
| DataPoint11 |
| DataPoint12 |
| DataPoint13 |
| DataPoint14 |
| ssssssssss |
| ssssssssss |
| ACO: web3.site3.coml: 1236549 - user.name1 |
| DataPoint1 |
| DataPoint2 |
| DataPoint4 |
| DataPoint5 |
| DataPoint9 |
| ssssssssss |
| ssssssssss |
| ACO: web4.site4.com: 9876542 - user.name1 |
| DataPoint1 |
| DataPoint9 |
| DataPoint10 |
| ssssssssss |
| ssssssssss |
| ACO: web5.site5.com: 9876542 - user.name1 |
| DataPoint1 |
| DataPoint4 |
| DataPoint5 |
| DataPoint9 |
| DataPoint10 |
| DataPoint11 |
| DataPoint15 |
| ssssssssss |
| ssssssssss |
<tbody>
</tbody>
