Hi Rob

Maybe example workbook 2 in the zip file is what you want ?
It use a data validation dropdown to make it easy
http://www.rondebruin.nl/accessexcel.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Rob" wrote in message ...
I am very good with Access but my boss is using Excel for this particular
project because of the calculation abilities. Can I create a pop up box that
prompts for parameters and shows the rows in the spreadsheet that meet these
criteria.