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.......

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.......