Macro that can sort and copy groups of data into separate spreadsheets

**glide2131** · 12-11-2014, 08:51 PM

In my attached spreadsheet I have a list of data in Column A of Sheet1 and I need a macro that can do the following:

1. Sort the data in Column A of Sheet1.
2. Find the all the data that matches exactly in Column A of Sheet 1.
3. Copy and paste each group of matches one by one to Sheet2.
4. Saving a new spreadsheet after each paste.

So basically the end result will be a different spreadsheet saved for each group of matches.
For example, On my spreadsheet I have 4 different groups. So I should have 4 different spreadsheets listing the rows on sheet2 of each spreadsheet.
The group names in Column A can be used as the sheet names.

Thanks

**JBeaucaire** · 12-11-2014, 09:09 PM

There is a possibility you've dumbed down the sample file too far.

I read that you are wanting to parse the rows of data from Sheet1 to new sheets in the workbook taking all the matching rows in column A.

'SHEET1 TO MANY SHEETS
Here's a macro for parsing rows of data from one sheet to many sheets named for the same values in a specific column.

Sheet1 to Many Sheets

It not only can parse the rows, it can create the sheets if they are missing. There is a sample sheet there where you can test this out.

Notice that row1 must be a title row, then the data starts in row2 and goes down as far as you'd like.

**glide2131** · 12-12-2014, 12:14 PM

Thank you for your reply. That code works great except for one item. I need to save each group individually instead of sending them or pasting them to their own sheet within the same workbook. Do you know how to do that?
So for example, if I had 4 groups this code would create 4 new sheets and save each group in each. What I need is to copy each group into a new sheet and then save it under a new name. So the end result will be 4 different workbooks.

**JBeaucaire** · 12-12-2014, 02:32 PM

Surprised you didn't find this there on the same site:

'ONE SHEET to WORKBOOKS (1)
Here's a macro for taking a sheet with data and creating individual wbs from each unique value in a chosen column. The date is added to the workbook names to give a reference as to when the wbs were created.

SHEET to WORKBOOKS(1)