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.