HOW DO I AUTOMATICALLY POPULATE AN INVOICE ON SHEET 2 FROM SHEET 1

G

Guest

Hi all,
I have a problem I have been attempting to resolve with no luck.

I have a Workbook with two worksheets :
Worksheet A - parts pricelist with the following columns.

Part No Description Price Quantity Total
===== ======= ==== ====== =====

Worksheet B is an Invoice.
I need the invoice populated whenever the quantity in the quantity column is
greater than zero and the total value is greater then zero. Bearing in mind,
this pricelist has over 4000 individual items. The values I require on the
invoice are the description, and quantity (the total is calculated
automatically on the invoice anyway).

Any help would be most appreciated.

Thanks all :)
 
C

Carim

Hi Sonny,

The function Vlookup() should do the job, provided there is a common
field (such as the customer name) between sheet1 and sheet2 ...

HTH
Cheers
Carim
 

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 on sheet 1 & data store on sheet 2 automatically 2
how do i make a formula to multiply two values? 6
How do I display 1 line per Invoice Summary w/totals from Invoice Detail ? 4
How do I move data from Excel worksheet to invoice? 1
Fill automatically from one worksheet to another based on cel valu 4
Data Entry Form: Complex Example 4
Frame an Invoice from the data available in a separate sheet of excel 2
How do I automatically pull a new invoice number into an excel te. 3

Top