hi all,

i've been trying for ages to figure this out.


i've got a backend that contains car information for all staff.


there's a frontend where the user can specify year, make, and model


i want it to select the matching backend data, copy it and paste it
to
another sheet. is there any easy way to do this?


i've been trying to use autofilter, but if the user wants to select
all cars made in 2000, 2000, 2001, or all cars that are toyota,
holden, or ford, autofilter doesn't work because it only lets you
filter a field on two criteria.


i don't want the user to be able to touch the backend.


thanks


Stefano

Create a helper column and add a formula there, like this

=OR(car="Ford",car="Toyota",car="Holden")

and filter that column for TRUE.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message
ups.com...
hi all,

i've been trying for ages to figure this out.


i've got a backend that contains car information for all staff.


there's a frontend where the user can specify year, make, and model


i want it to select the matching backend data, copy it and paste it
to
another sheet. is there any easy way to do this?


i've been trying to use autofilter, but if the user wants to select
all cars made in 2000, 2000, 2001, or all cars that are toyota,
holden, or ford, autofilter doesn't work because it only lets you
filter a field on two criteria.


i don't want the user to be able to touch the backend.


thanks


Stefano