Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
extract data from backend, display on frontend
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please advise on the production of a frontend, to view selected record(s) of a completed worksheet | Excel Programming | |||
Create form in Access, use as frontend for Excel | Excel Discussion (Misc queries) | |||
Excel backend for IIS | Excel Discussion (Misc queries) | |||
Excel Front End , SqlServer Backend in the web | Excel Programming | |||
mysql backend | Excel Programming |