Invoice setup

P

PK Atkins

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

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

PK Atkins said:
I am trying to link the information from a table to the invoice. How can I
Click to expand...
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.
 
J

JulieD

sent

PK Atkins said:
Hi,

Can you please email me that form please. email address is [email protected].

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.
Click to expand...
 
Top