Macro to separate data into tabs

Thank you very much. I used the solution from Stanleydgromjr and it works great.


I'm attaching a spreadsheet with what I would like the end result to be. Basically I need each set of data between the DN headings to be put into a separate tab. It doesn't matter if the orginal tab is left as is or not. Does that make sense?

thanks,

Tami


Each week I receive a report where I need to separate the data into a new tab for each different grouping of data. I'm hoping I can get a macro to do this but don't know anything about writing them. Each new section starts with the heading of DN and the unique value for the data is at the end of the column (CMUTUAL.COM or CMUTUALD.COM or CMUTUALM.COM etc). The number of rows in each grouping of data varies from week to week. The first grouping could be 700 one week and 720 the next. Same for the second and third groups.

I've attached a sample of what my data looks like.

Hope someone can help. Thank you.