Cut and paste row containing certain keywords

[Closed]
Report
Posts
2
Registration date
Tuesday February 7, 2012
Status
Member
Last seen
February 8, 2012
-
Posts
2
Registration date
Tuesday February 7, 2012
Status
Member
Last seen
February 8, 2012
-
Hello,

I am wanting to be able to run a macro that will cut and paste into a new sheet any rows that contain certain keywords

Is it possible, I am using Excel 2010 and can anyone assist

thanks in advance

2 replies

Posts
2
Registration date
Tuesday February 7, 2012
Status
Member
Last seen
February 8, 2012
1
Hi I'll try to elaborate.
In a spreadsheet column B would have numerous company names that I wish to automatically sort then cut and paste them into a new sheet for each of the account managers.
Key word may oocur several times on the sheet.
I already have a macro that deletes the clients that we no longer deal with but I want to be able to run another one that quickly sorts them in sheets for the account managers

Does that explain it better?

thanks
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
information too vague
if the key words occur only once use "find" function and copy the row
if they occur in more cells use autofilter and copy filtered data

I am using only excel 2003 and 2007. excel2010 may have some other
advances