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