Hi,

I did some search whithin the forum and looked at a few formulas (i.e.
VLOOKUP...) but couldn't find a solution.

I am creating a budgetary quote generator document, which consists of 2
worksheets. The first worksheet "PRICE-LIST" contains a list of all items for
sale by my company. You just have to enter the quantity desired for each
items wanted.
For each row I have an product item with it's part #, description, price...

The second worksheet "QUOTE" is just a budgetary quote, that gives a total $
amount. All I want is excel to fill the QUOTE worksheet automatically will
all products selected in the "PRICE-LIST" (quantity value >= 1) and to be
able to fill a line for each product. I would remove the price list
information (for example) in the QUOTE worksheet.

Below is an example of what it would look like. Quantity is the only field
to fill manually. The rest should be automatic.

--------------------- PRICE-LIST worksheet
------------------------------------------
Part# Name Description Unit Price Quantity Total
111 ABC blablablal $10 1 $10
112 DEF blablablal $20 0
113 GHI blablablal $5 2 $10

--------------------- QUOTE worksheet
------------------------------------------

Dear Mr. John,

the total for this project is: $20
This includes the following items:

Part# Name Description Quantity
111 ABC blablablal 1
113 GHI blablablal 2

----------------------------------------------------------------------------------


Thanks again for anyone's help ! I appreciate