Filter and Save as new workbooks

**pmhabo** · 06-29-2011, 04:11 PM

I need to create a macro that will auto filter rows by column A and for each filter save as a new workbook that is titled by whatever is filtered in Column A.

A, B, C
Rob, 2, 4
Nick, 1, 3
John, 10, 20
Rob, 50, 100

So first filter would create:
A, B, C
Rob, 2, 4
Rob, 50, 100
and save as a new workbook titled "Rob", and it would exclude all other data (nick/john data) in the Rob workbook

any ideas?

**royUK** · 06-30-2011, 02:51 AM

Try this

Please Login or Register  to view this content.

**reviole** · 07-07-2011, 10:59 PM

thankyou.. this work like charm

**royUK** · 07-08-2011, 02:20 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save