I have a workbook with data that looks something like this (except thousands of entries):
Name Type Group Master John Big a 1 Rick Small a 0 Jack Big b 0 Rob Medium b 1
I need a macro that will copy data to new workbooks and save them individually based on the value in column C (Group). The macro needs to select all rows that have the same group (same value in column B) and then copy/paste them into a new workbook and save it in the same folder as the base workbook. In the above example, it should copy the two rows that have the group "a" (value = a in column C), copy (or move completely) them to a new workbook and save it, then select the rows that have the group "b" (value = B in column C) and do the same. The main workbook has thousands of rows and hundreds of groups.