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

S

Sonny

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
template creates invoice - how to create summary worksheet? 13
is this possible in excel 2007 3
Invoice spreadsheet 3
Invoice Numbers created automatically 2
Calculate accumulative total, based on conditions of two different 2
Hide rows of one sheet based on values in another sheet? 2
How do I set up an automatic invoice number in Excel 2007 2

Top