Macro needed for extracting to Tab

[KiloHotel]

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:

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!

 

[Fluff]

Glad to help & thanks for the feedback

 

[KiloHotel]

Glad to help & thanks for the feedback

No problem, I wish i had your knowledge on this stuff!