Big problem with doing one part of invoice

[doobi]

I've got a problem. I have to do invoice (that's easy) 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

 

[Ron de Bruin]

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