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
stocks100 Posts 2 Registration date Tuesday February 7, 2012 Status Member Last seen February 8, 2012 - Feb 8, 2012 at 12:54 AM
Related:
- Cut and paste row containing certain keywords
- Youtube channel keywords - Guide
- Saints row 2 cheats - Guide
- How to search keywords on chrome - Guide
- Short cut key for at the rate - Guide
- Power supply connectors keywords - Guide
2 responses
stocks100
Posts
2
Registration date
Tuesday February 7, 2012
Status
Member
Last seen
February 8, 2012
1
Feb 8, 2012 at 12:54 AM
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
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
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Feb 7, 2012 at 04:54 AM
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
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
