Automate name look-up?

  • Thread starter Thread starter biben
  • Start date Start date
B

biben

In a worksheet invoice I want to put in my Custumer addresses and that
the adresses is saved on another worksheet to a custumer database.
How do I do to save the adresses to another worksheet?
Can It be done automaticly in some way?

If a certain custumer comes back and I start to type the name in
would like a function that recognize the name and in a drop down lis
gives me names to choose from and fill in the rest of the addres
automaticly.

Has anyone succeded with this or are able to help me with thi
problem?

/bibe
 
Hi

Have a look at Data Validation. I would also recommend visiting Debra's
site:
http://www.contextures.com/xlDataVal01.html

Andy.

biben said:
In a worksheet invoice I want to put in my Custumer addresses and that
the adresses is saved on another worksheet to a custumer database.
How do I do to save the adresses to another worksheet?
Can It be done automaticly in some way?

If a certain custumer comes back and I start to type the name in I
would like a function that recognize the name and in a drop down list
gives me names to choose from and fill in the rest of the address
automaticly.

Has anyone succeded with this or are able to help me with this
problem?

/biben


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top