Big problem with doing one part of invoice
 

I've got a problem. I have to do invoice (that's easy:D) but in this
invoice when have to fill in clients name adress etc it's much bigger
problem, because I must do table with clients and in this invoice I've
got to do a list in one cell with surename of client from that table.
when I pick up a surname from the list the rest data from table must
fill in another cells. I don't have any idea how to do this. I've read
Excel users guide but I didn't find how to do this. PLEASE HELP ME!!!

Regards
doobi

Big problem with doing one part of invoice
 

Hi doobi

You can greate a dropdown with all names and then use Vlookup formulas to pick up the information.

See
http://www.contextures.com/xlDataVal01.html

The look here
http://www.contextures.com/xlFunctions02.html


--
Regards Ron de Bruin
http://www.rondebruin.nl


"doobi" wrote in message oups.com...
I've got a problem. I have to do invoice (that's easy:D) but in this
invoice when have to fill in clients name adress etc it's much bigger
problem, because I must do table with clients and in this invoice I've
got to do a list in one cell with surename of client from that table.
when I pick up a surname from the list the rest data from table must
fill in another cells. I don't have any idea how to do this. I've read
Excel users guide but I didn't find how to do this. PLEASE HELP ME!!!

Regards
doobi