ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Invoicing (https://www.excelbanter.com/excel-programming/300792-invoicing.html)

Prakash

Invoicing
 
I am trying to link the information from a table to the invoice. How can I do it?. For an example, Create a drop down menu in one of the column in the invoice, which information should be extracted from the table's certain coulmn. On the next column of the invoice again create a drop domn menu, which information is extracted from a certain row from the table. Then all the other information such as number of units and price should appear as the matching of the previous two information.

Thnx.......



Ron de Bruin

Invoicing
 
Hi Prakash

Look in the Excel help for the Vlookup function

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


"Prakash" wrote in message ...
I am trying to link the information from a table to the invoice. How can I do it?. For an example, Create a drop down menu in one

of the column in the invoice, which information should be extracted from the table's certain coulmn. On the next column of the
invoice again create a drop domn menu, which information is extracted from a certain row from the table. Then all the other
information such as number of units and price should appear as the matching of the previous two information.

Thnx.......






All times are GMT +1. The time now is 05:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com