CollegestudentHelp me create an automated data entry program in Ex
 

I have detailed customer information and I want to be able to type in the
customer ID and have the rest of the information fill itself in. Please
help. All in Excell.

use vlookup function. see help


Desperate College Student <Desperate College
wrote in message
...
I have detailed customer information and I want to be able to type in the
customer ID and have the rest of the information fill itself in. Please
help. All in Excell.

As suggested you can use the VLOOKUP function. There are instructions
and examples he

http://www.contextures.com/xlFunctions02.html

And a sample file he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Invoice for Selected Number'

Desperate College Student wrote:
I have detailed customer information and I want to be able to type in the
customer ID and have the rest of the information fill itself in. Please
help. All in Excell.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html