Can someone please help me to delete a large proportion of an Excel spreadsheet.

The spreadsheet has around 1000 rows. Around 600 rows have common data in one of the columns, and I want to remove those 600 rows from the table and either paste them to a new worksheet in a new file, or delete them permanently.

Have attempted to do this by using autofilter to only show the rows that meet the criteria, then deleting the rows but this seems to also delete the rows which are filtered out. Have also tried the same but cutting/pasting the selected rows to a new sheet, but this has the same effect.

I'm sure there is a straightforward method to do what I need, but had a mental block today, and cannot get my ickle brain round it


Edit cos I cant spell either




[Edited by Figment - 8/5/2002 11:40:48 PM]

 

go to bed ...

#software solution no 229

 

Sort the rows so that the ones you want to cut are adjacent?

 

As I said above, there has to be a straightforward method.

Thanks Kevin