Here is my scenario:

I have two workbooks in one xls file. Workbook 1 takes values from
Workbook 2 and formats them as a receipt. I have 10 products on
Workbook 2, each with a different name and a different price.

What I need for Workbook 1, is a way to:

1. detect when I have a value other than "0" in the quantity cell on
Workbook 2
2. If the quantity is >0, enter the quantity into a cell in Workbook 1
3. multiply the cell value that is the quantity by a designated price;
the price of the product.


How do I accomplish this?

Thanks.