Macro to seperate tables based on column b

[max8719]

Hi All,

I have a table from columns A to K with no specific number of rows as this can vary.

Row 1 is the header of the table.

In column B, row 2, I have a name and the cells under are blank up to the next name and so on.

I would like to seperate the table based on the intervals in column b, so a new name starts a new table in effect using the header from row 1.

Any ideas would be much appreciated.

 

[max8719]

If the new tables can go on their own sheet too, whilst keeping the same formatting as the original, that would be ideal