I have a product list that is stored on a separate worksheet within the
same workbook.

My question is there a away to use the auto filter where the list is
stored to only show the product numbers that apply to filter and
display only these part numbers in the dropdown menu on the main
worksheet.

This spreadsheet are part of a shared workbook, will this create
problems.


--
lostinformulas
------------------------------------------------------------------------
lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229
View this thread: http://www.excelforum.com/showthread...hreadid=561557