B
buattis
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
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