software

Hello,
I have spreadsheet with thousands of records. I need to pull out all records
from first coloumn ending with quot;icquot;, and have spreadsheet sorted so those
records are on the top, or bottom, or create new spreadsheet with searched
records and delete them from the old one.
If that is not clear enough, I need to split the list into records that have
quot;icquot; at the end of first cell, from the rest of records.
I have some VBA experience, but never worked with Excell.
Thanks!
--
Deki PAOn Wed, 15 Mar 2006 14:49:40 -0800, Deki
gt; wrote:

gt;Hello,
gt;I have spreadsheet with thousands of records. I need to pull out all records
gt;from first coloumn ending with quot;icquot;, and have spreadsheet sorted so those
gt;records are on the top, or bottom, or create new spreadsheet with searched
gt;records and delete them from the old one.
gt;If that is not clear enough, I need to split the list into records that have
gt;quot;icquot; at the end of first cell, from the rest of records.
gt;I have some VBA experience, but never worked with Excell.
gt;Thanks!

Easiest way is to use Data--gt; Filter--gt; AutoFilter. Make sure your
cursor is somewhere in your data before selecting this. Then click on
the drop down arrow in the first column, choose Custom Filter, select
the 'ends with' option, and type quot;icquot; in the box to the right.

You can then copy them all and paste elsewhere. Then delete them
before cancelling the Data Filter.

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________