Search a column for a certain criteria and cut and paste in new sheet.

[awagenhurst]

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

[davesexcel]

Attach a sample workbook.

When you are in Advanced reply, click on the paperclip to open the upload window.

View Pic

[awagenhurst]

example.xlsx

Well here is the Example in the spreed sheet you'll see 3 different types of vendors, (SYSCO, KEANY, GFS) What I'm trying to do is create a macro that will take this list and search by column E and see Sysco and put that in a new spread sheet, put keany in a new spread sheet put GFS in a new spread sheet. instead of filtering copy and paste so sheet 1 will have all of sysco with column A:O and the samething with Keany and GFS.

[CityInspector]

try this

Please Login or Register  to view this content.

This would run when data was entered in column O. It worked for me in a similar issue so hopefully it will work for you. You could change it so it would run when data was entered in a different cell by if that works better.

[awagenhurst]

outcome.xlsxIt worked but it's not what I was looking for I dont want a search box to come up I kinda want the macro to search column E and see that there are different names and cut and paste the different names with the entire row in a new sheet. I attached what I want the outcome to be.

[awagenhurst]

Ok so it took me about 3 days to do it but I figured it out on my own it does exactly what I want it to do and I love it. Just shows you what you can do when you want something bad enough