try to create a subtotal one row after the end of the data.

does it helps?
Marcelo

"kjp" escreveu:

I could but can I still get the totals rows at the bottom to appear somehow?
When I tried the autofilter, the last line, which is grand totals,
disappeared and I couldn't make it apear until I took the filter off.

"Marcelo" wrote in message
...
Hi, why not to use a auto filter?

does it helps?
regards from Brazil
Marcelo

"kjp55" escreveu:

I have a basic spreadsheet and need to import data from that sheet into a
new
sheet, based on criteria from one colum in the original sheet. Can't
figure
out a formula for this.

Sheet One (Printing press waste calculator)

col1 col2 col3 col4 col5 col6
col7 col8 col9
date job operator ordered start # stop # run
var -+ var %

6-6-06 test Dan 5,000 415250 420450 5200
200 4%
6-6-06 test Sam 5,000 415250 420450 5200
200 4%
6-6-06 test Ed 5,000 415250 420450 5200
200 4%
6-6-06 test Dan 5,000 415250 420450 5200
200 4%
6-6-06 test Ed 5,000 415250 420450 5200
200 4%
6-6-06 test Sam 5,000 415250 420450 5200
200 4%

I need a new sheet for each operator, importing all rows of data, but
only
by the operator's name. So, the resulting worksheet will show everything
(like above) but will only show data for a particular operator.



I need the new sheet to import all data