Updating a list

[ccoles]

I have a simple Excel sheet. Basically users choose an item from
validated list. This then uses a vlookup to find the number in stock
The user can specify how many they want and all I want to do is just t
decrease the number in stock by the number required. I thought it migh
be something as simple as:
=vlookup($B$4,vl_stock,2)-$B$6 etc but this reduces all of the number
on the stock list for all items. I am sure there is a simple explanatio
but I spent a day looking for a solution on the net yesterday and go
nowhere.
Would appreciate any insights you might have

 

[Dave Peterson]

I think you could use some kind of macro to do this, but I'd really be worried
about what happens when I update that number--and that number is actually a
typo.

I think I'd use another worksheet with nice fields (date/user/part
number/qty/etc) to keep track of accurate records.

Then I could build a pivottable that would summarize what's remaining.