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