Hi

I have a question I'm hoping people here can help with. I'm going to try to
be as clear as I can !!! Right!

In tab one on a worksheet (called "Assetts") column D holds the assett
number for a product (D2 being the first number). Sample below :

Description Date Rec Supplier Prod No Purchase Price List Price Qty

On tab 2 (called Orders) column A holds the product number that has been
order (i've then got a formula which enters the price I paid for the
product). Column C on the same tab holds the quantity of products ordered for
the product number entered in column A tab 2. Below is a sample :

Product ID Date Sold Quantity Req Sale Price Customer ID Price
6825 21/03/2006 1 £4.99 5 £4.99

Now for the question - when I enter the product number in Colum A, tab 2, I
would like to either :

1) when the prodcut ID is entered in tab 2, a formla is run to lookup that
number in the assetts tab, then references the quatity, and then removes that
quantity from the assetts tab.

2) some other idea!!!!!

Sorry if this is too much but thanks for any help in advance.

Bill