Automate name look-up?

[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

 

[Andy B]

Hi

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

Andy.

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

creating financial statements