OK, I'm new to macro's I've did very basic stuff. But now I'm stuck I need a macro that that would continue to loop through a coulmn and if the search finds the criteria it would cut the entire row its in and paste it in a new sheet. If there is like more than two different types I want each different types in a new sheet.

This is the only Example i could think of.




bob...1...2...3...4...5
bob...1...2...3...4...5
the...1...2...3...4...5
bob...1...2...3...4...5
the...1...2...3...4...5
the...1...2...3...4...5
and...1...2...3...4...5
and...1...2...3...4...5
bob...1...2...3...4...5
and...1...2...3...4...5



Say i wanted to filter out anything thats not bob.. the macro would see the, and... the macro would remove them and put them in seperate new sheets
so sheet 1 would be this


bob...1...2...3...4...5
bob...1...2...3...4...5
bob...1...2...3...4...5

second sheet
and...1...2...3...4...5
and...1...2...3...4...5
and...1...2...3...4...5

third sheet
the...1...2...3...4...5
the...1...2...3...4...5
the...1...2...3...4...5


this is the only way i could explain it. sorry if needs more explaning post back

thank you