invoicing from drop down menus

[Guest]

Wanting to build a rather complicated invoice template which will automatically fill in certain customer information from a database when name is entered or chosen from a drop down list, and then print and save the resulting invoice, as well as distributing and saving key item and financial data from the invoice

The invoice templates offered with Excel and through Microsoft online are WAY simple compared to what I need. Is this drop down list function a feature of Excel? What is the tool called? I've used another spreadsheet program in the past, but am a true novice with Excel

Does anyone out there have specific template experience that is similar? Is this something I don't want to tackle unless I know programming language?

 

[Frank Kabel]

Hi
have a look at
http://www.contextures.com/xlDataVal01.html

 

[Hans]

Hi

There is a nice excel file you can download at:

http://www.contextures.com/excelfiles.html#DataVal

See: Invoice for Selected Number

Hans

-----Original Message-----
Wanting to build a rather complicated invoice template

which will automatically fill in certain customer
information from a database when name is entered or chosen
from a drop down list, and then print and save the
resulting invoice, as well as distributing and saving key
item and financial data from the invoice.

The invoice templates offered with Excel and through

Microsoft online are WAY simple compared to what I need.
Is this drop down list function a feature of Excel? What
is the tool called? I've used another spreadsheet program
in the past, but am a true novice with Excel.

Does anyone out there have specific template experience

that is similar? Is this something I don't want to tackle
unless I know programming language?

 

[Guest]

Frank & Hans-

MUCHO GRACIAS!