It seems that a split existing data to new worksheets macro is a fairly common request, however from my searching online, I haven't managed to find one that satisfies what I need, and my VBA skills are not quite good enough to write this myself, or successfully adapt an existing version from the ones I have viewed so far, so I would be very grateful if someone had some existing code they could share that can be adapted.

The worksheet I need splitting stretches from column A to AV (perhaps further in future), and I would like the splitting to start from row 8, with row 6 being the headings and row 7 being blank. If possible, I would like the headings copied across to each new worksheet, as well as all existing formats.

Ideally the names of the new worksheets should be the same as the data in column B that the split is created on, however some of these headings have too many characters to fit into the worksheet name. Can this be managed without manual editing?

There are other existing worksheets in the workbook. These should remain.

Aside from these, I think it should be a pretty simple request for someone with a greater knowledge than me!

Many thanks in advance.

Ps. I can share a workbook if this is required but will have to create a 'non-sensitive' version for online posting. Let me know.