Cut and paste row containing certain keywords

Closed
stocks100 Posts 2 Registration date Tuesday February 7, 2012 Status Member Last seen February 8, 2012 - Feb 7, 2012 at 02:09 AM
stocks100 Posts 2 Registration date Tuesday February 7, 2012 Status Member Last seen February 8, 2012 - Feb 8, 2012 at 12:54 AM
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

stocks100 Posts 2 Registration date Tuesday February 7, 2012 Status Member Last seen February 8, 2012 1
Feb 8, 2012 at 12:54 AM
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
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Feb 7, 2012 at 04:54 AM
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
0