Sun, 16 Sep 2007 08:46:00 -0700 from Martin Ellis
<MartinEllis@discussions.microsoft.com>:

Sort first, so that the lines to be copied are continuous.

You need not save the worksheet after sorting, if you want to
preserve the original order.

Martin

Click on the Auto Filter down arrow in the column that contains the data
that you wish to filter on, and choose 'Custom'.
In the dialog box on the left, click the down arrow, and choose "Ends with".
type in the box on the right-hand side -30 or whatever, click OK.

George Gee

Excel sheets consist of cells, rows and columns.

Rows run across the sheet from left to right and Columns run vertically from top
to bottom.

You are trying to select cells which are just parts of a row.

To select entire rows, hold CTRL then click on the row headers at left
side.................the 1,2,3,4,5 etc.

In this manner you can select 1,3,7,9,31 etc.

You would be better off using the autofilter to get the rows you want.

Use a custom filter on column C with "contains"  "-30" to get all rows with -30
to be visible.  The others will be hidden.

Also, since you say you don't know what a row is, perhaps a basic tutorial would
assist.

Here are a few basic tutorials for Excel to get a beginner going.

http://www.usd.edu/trio/tut/excel/index.html

http://www.baycongroup.com/el0.htm

http://office.microsoft.com/en-us/training/CR061831141033.aspx

Gord