| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum of a invoice- problem with vlookup | Excel Discussion (Misc queries) | |||
| invoice problem | Excel Worksheet Functions | |||
| missing invoice toolbar when save customised invoice | New Users to Excel | |||
| Invoice templet Excel97 to 2003 invoice toolbar missing | Excel Discussion (Misc queries) | |||
| How do I change the invoice number assigned in Invoice template... | Excel Discussion (Misc queries) | |||
Linear Mode
