Invoice setup

[Guest]

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

 

[JulieD]

Hi PK

for the drop down in the invoice linking to the table, use Data Validation -
List
for the auto-population of the unit (?) & price use VLOOKUP

if you'ld like a sample of an order form that has the above please email me
direct and i'll send it to you.

Regards
JulieD

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.

 

[Guest]

Hi,
My email address is (e-mail address removed). I would like the sample form

Thn
Prakash......

 

[JulieD]

sent

Hi,

Can you please email me that form please. email address is (e-mail address removed).

Thnx
Prakash....
----- JulieD wrote: -----

Hi PK

for the drop down in the invoice linking to the table, use Data Validation -
List
for the auto-population of the unit (?) & price use VLOOKUP

if you'ld like a sample of an order form that has the above please email me
direct and i'll send it to you.

Regards
JulieD

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.