Updating data

[artham56]

Hi,
I have a Worksheet(stock) of about 30 stock sizes with quantities which from another worksheet(quote) I can check availablity using Vlookup. If the quote then becomes a sale I would like to automatically update the stock sheet quantities against the stock size sold.
Supposing "Stock" worksheet shows cell A10 is Stock no "115270" and cell B10 shows 20 in stock when I produce my quote I have no problem looking up the stock no and showing the quantity in stock on my quote worksheet say in cell D16 but if I then sell 4 and minus them from the 20 I cant seem to find a way to then update Stock sheet B10 with the new balance.
I think a macro would be the best option but cant work it out! Can someone help please?

[arthurbr]

This post looks a lot like this one : http://www.excelforum.com/excel-work...ting-data.html
If you need to transfer to another forum, PM a mod who will do it for you

[arthurbr]

Thread closed after message with the OP