Hi all,
I am wondering if there is a way of extracting a range of cells into seperate tabs from the one long sheet.
Let me give you my issue,
I have one sheet with alot of tables and data, Someone glued it all together and i need each table into separate tabs,
At present it is currently like this:
<tbody>
</tbody>
So Anywhere Cell A & B say SOB & BBEE it is a new table all the way down until it says it again. The tables vary in length and they are not all the same. but there is 250+ tables all glued like this (idiotic) but i am screaming for help at this stage if anyone can please
Thanks!
I am wondering if there is a way of extracting a range of cells into seperate tabs from the one long sheet.
Let me give you my issue,
I have one sheet with alot of tables and data, Someone glued it all together and i need each table into separate tabs,
At present it is currently like this:
SOB | BBEE |
TEST 1 | TEST1 |
TEST 2 | TEST3 |
TEST 3 | TEST3 |
SOB | BBEE |
TEST11 | TEST11 |
TEST12 | TEST13 |
<tbody>
</tbody>
So Anywhere Cell A & B say SOB & BBEE it is a new table all the way down until it says it again. The tables vary in length and they are not all the same. but there is 250+ tables all glued like this (idiotic) but i am screaming for help at this stage if anyone can please
Thanks!