Macro to create a new worksheet at each change in data

I have a macro that may be "ready to use" for parsing rows of data from one sheet to many sheets named for the same values.

Sheet1 to Many Sheets

It not only can parse the rows, it can create the sheets if they are missing.

There's a sample workbook so you can test it and see it is pretty much exactly what you've described above.

Sound like you need to change the vTitles to "A9:ED9"...

Next, the "customize this section"...sounds like you just want everything from A1 down to the bottom of the filtered data, actually simpler than my code...

Please Login or Register  to view this content.

These are some very specific tweaks. If they don't work, post a sample workbook so we can test these things together. Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.

Thanks for your help.

The initial macro you sent me is pretty much perfect, in that it does almost exactly what I am looking for, so I don't want to lose any of those features. I just need to figure out how to allow for:

1) There is common data that needs to be on the top of each worksheet. And
2) There is a row of common data (summation in this case) that needs to go at the end of the pasted data on each worksheet.


I can figure out how to copy the common rows of data to each new worksheet (rows 1-9). That is not a problem. What I can't figure out is how to make your formula start "working" with row 9, and then paste the data starting with row 9 on the new worksheets.


I have attached a very basic sample of what I am talking about. I hope this will help illustrate. In the workbook I have 4 tabs:

Tab 1 - initial data. This is how the workbook would start out. The macro would be run here to end up with the other three tabs.

Tabs - Bill, Dave, and Eugene.. These wouldn't be there. These are just to show what I am hoping the end results would be like.
As you can see, this is almost identical to the initial macro you sent me, the differences being the header information that gets copied over, and the summation row at the bottom of the data on the new worksheets.

Thanks for your help.

1) There needs to be a complete list of answers in column A, list the sales manager for each row, keep it simple. Do you really even need this column? Something to think about.

2) In the totals row, you should use the SUBTOTAL() formula instead of SUM(). SUBTOTAL() will adjust its own answers in relation to how many rows are visible in a filtered list.

3) In the totals row, there needs to be at least one cell that is empty so we can look UP through that column to see how many rows of data are visible not counting the totals row. I've left column B cell empty so we can also get a clean list of values in column B for the sheet names, moving the TOTAL cell eliminates the need to exclude the word "Total" from our sheetname list.

Please Login or Register  to view this content.