Hey guys,

I'm using a program for work that extracts data and creates my financial statements. However, I have been asked by my superiors to see if there is a way to split up the financial statement based on the different types of fees and expenses, but do it in a way that it isn't a manual copy paste.

Since each row has a different heading (and there are a lot of rows), I created some if statements to make it so each row then has a title based on the type of income or expense it is. Currently, there are 12 different 'Titles', but there may be more if they want me to break things out into more detail, or less if they want to combine things.

What I am trying to figure out is a Macro that will take each change in 'Title', which is located in column D, and separate the data into a new tab (Column D doesn't have to be brought over but it will just be hidden if it is). This certain report has data that goes from Column E, to Column CS. I have one that is 3 times as wide that I would need to use this for as well.

I would like it to copy over all formatting, as well as the headers located in Rows 1-10, and hopefully column widths too if we can. Also, is it possible to make the new tab the same label as the 'Title' in column D? For instance, instead of it just being 'Sheet1', it would be 'Fee Income' or 'G&A Expenses'?

I would post a copy of the worksheet but since it is financial data, I'm not able to. I know it's a little hard to imagine without it, but hopefully that is enough detail to work off of? I would really appreciate any help!