I have an organization with a large membership database that I use for monthly reporting. Instead of manually dividing members into different groups, I'd like to create a macro to do this. Each member has an identifying "number" e.g. AB1234 with AB signifying which specific organization that member belongs to. So my database will have, say, 1000 AB members, 1000 ** members, 1000 EF members and so forth. Another wrench in the works is that the number in the AB, **, EF, etc. groups changes every month, so I can't just write a macro that pulls cells 1-1000.

How do I write a macro that will filter each group onto a separate tab in a workbook? Another option would be to create a macro that saves one group per workbook (say the AB group) and deletes the rest. I'd actually prefer the latter option.

Thank you for your asstance!