Formatting a cell to utilize list and auto populate

A

Amy Mucke

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Populate One Pages from spreadsheet 0
Auto populate value from one task to another in MS PROJECT 0
Document Merge Formatting Issue 0
Insert name and adress from a list in a word document 1
Creating a Search using a combo box and then creating a report. 4
VBA to see if a Section exists in Word Document, and if it does, delete it 2
Outlook meeting location auto prompts with a suggestion list - need to disable 0
VLook-Up Possibly Conditional Formatting 1

Top