I am creating an invoice/quote, in the column where I want the part number I
want to reference another worksheet that contains the part numbers which is
about 10,000 items. When that part number is selected I want to the auto
populate the description. How can I do this? Then I will save the form under
an invoice/quote number. Can I do this vice versa too? Select the
Description and autopopulate the part number?

My thought is like when you search on the internet and it suggests the rest
of the word you might like to select...."Search Assist".

Does anyone know how to do this? By the by I only have Excel 2000 at work
but I have 2007 at home.
--
Amy