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

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 :)

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

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