Yes, that worked but it still shows the totals for the entire columns, all
records. Is there a formula to make it only calculate and show a sub-total
of the filtered records, instead of showing the sum of 'all' records? And
then still having the master total of all records at the bottom when 'all
records' is selected in the filter?

Thanks for your patience.

"Marcelo" wrote in message
...
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