Invoicing

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Look in the Excel help for the Vlookup function

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


Prakash said:
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
Click to expand...
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Invoice setup 3
VBAscript for data matching excels 0
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Copy a range instead of just one row but with condition 8
Copy data automatically from another workbook 5
Snag in invoice generator. How to change the "series" 5
Dynamic Table Problem 1

Back
Top