Hi! I need help with two excel questions. I'm just starting to use excel
macros and such, and right now I need to create a combobox that will "fill as
I type", so that I can input the first letters of the data and it will filter
through all 2,000 to just those that start with those letter.

For Example: I have my "database" on one worksheet called "data" on excel,
and on another sheet I need to create these comboboxes that will use the
"data" as it's database, but as I start typing--- let's say POL, it will show
on a dropdown list all of my vendors who's 1st three letters are POL. Is this
possible? Do I need macros for this? Could anyone help my with the VBA code I
might need for this?

#2) I need to create an autonumber sequence for a "receipt" type of excel
document, so that everytime I print/save the document, it will add 1 to the
sequence number set on a specific cell?

*** Access is not allowed @ work, which is why I have to do this on Excel.

Please I would appreciate any help any one can provide.

Thank you!!!