I would need to auto update the numeric value in a quantity column, when I select the specific item in another sheet.
Sheet1 being the bill (product, quantity sold, price per unit, total)
Sheet2 having the products info (name, price, quantity)
In Sheet1 I would select a specific item in A1, and will digit the number of pieces in A2, in A3 I'll have the price shown from Sheet2, and in A4 I'll have A2*A3
Please see http:Q_23132180.html
Once I put the quantity sold (Sheet1-A2), I'd like quantity (Sheet2-B1) to be updated consequantly.