Alistair,

Sounds like a candidate for Data Validation.

Take a look at Debra Dalgleish's site at
http://www.contextures.com/xlDataVal01.html

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"alistair01 " wrote in message
...
How would i go about creating a sheet which contains dropdown lists to
filter data. i have a workbook with multiple sheets the first of which
contains a database linked by a query from access to excel. what i want
to do is to create a user interface which the user will be able to
select which data from the database the user wants to see. Any
suggestions would be much appreciated!


---
Message posted from http://www.ExcelForum.com/