Sorry to sound thick Gord, but this is a new Excel user forum and I don't
really understand what you mean.

You refer to rows, but it's entire lines I need to copy.

An example line is:
(A) -2.23277 (B) 53.48145 (C) Redlight:1419-30
(A) -3.25674 (B) 47.17895 (C) Redlight:2786-60

It's the -30 (or 60) at the end which I want to sort by, but surely if I use
Auto Filter, I'm still not going to be able to choose the entire line which
contains the filtered information...or am I missing the point?

Martin Ellis

"Gord Dibben" wrote:

Martin

Try autofiltering for each number then copy the results to the new workbook.

DataFilterAutofilter. When filtered, F5SpecialVisble cells onlyOK

Copy those rows to your sheet in new book.

Or without filtering, just use CTRL + click on entire rows and copy those.

Excel will not allow single non-contiguous ranges to be selected and copied but
will allow non-contiguous rows or columns.


Gord Dibben MS Excel MVP

On Sun, 16 Sep 2007 03:28:00 -0700, Martin Ellis
wrote:

I have a .csv format file listing speed cameras, and the different speeds are
identified by two characters at the end of each line - 30, 40, 50 etc.

I would like to create separate files for each speed, but Excel won't allow
me to cut/copy several lines to created a new file/workbook. Is there any way
round this?

Martin Ellis