Updating a list

[[email protected]]

I have a simple Excel sheet. Basically users choose an item from a 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 to decrease the number in stock by the number required. I thought it might be something as simple as:
=vlookup($B$4,vl_stock,2)-$B$6 etc but this reduces all of the numbers on the stock list for all items. I am sure there is a simple explanation but I spent a day looking for a solution on the net yesterday and got 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.



"[email protected]" wrote:
>
> I have a simple Excel sheet. Basically users choose an item from a
> 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 to
> decrease the number in stock by the number required. I thought it might
> be something as simple as:
> =vlookup($B$4,vl_stock,2)-$B$6 etc but this reduces all of the numbers
> on the stock list for all items. I am sure there is a simple explanation
> but I spent a day looking for a solution on the net yesterday and got
> nowhere.
> Would appreciate any insights you might have.
>
> --
> [email protected]
> ------------------------------------------------------------------------
> [email protected]'s Profile: http://www.excelforum.com/member.php...o&userid=19962
> View this thread: http://www.excelforum.com/showthread...hreadid=345877

--

Dave Peterson