I hope someone can point me in the right direction. Basically I would
like to create a "invoice" type of form. I can whip it up in Access
and generate the report very easily but I am unable to do it in Excel.
I am limited to Excel, Word and Filemaker for this task. Trying to
avoid Filemaker.

The user must be able to pick from a drop downlist the product. I have
this working and it works great but we have 10000 lines (yes that isn't
a typo), from which to pick from. I would like to be able to create a
search function or even break it down into categories, but I don't want
the user to have to copy the data from one sheet to another. I was
trying this with filter.

Any suggestions.

Sharon

You could do this by pasting the 10,000 product numbers, descriptions
etc into a grid on a tab in the workbook. Highlight the product number
and create a named range that refers to that range: a1:a10000, for
instance. Hide that tab, and on your invoice tab create an in-cell
dropdown (called data validation) that allows entries only from the
list that is contained in your named range. That way the user will be
able to select the part number or whatever from the dropdown, and the
Description, Price etc fields can populate with VLOOKUP formulas in the
invoice.