Updating a list
 

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.


--

------------------------------------------------------------------------
's Profile: http://www.excelforum.com/member.php...o&userid=19962
View this thread: http://www.excelforum.com/showthread...hreadid=345877

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.



" 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.

--

------------------------------------------------------------------------
's Profile: http://www.excelforum.com/member.php...o&userid=19962
View this thread: http://www.excelforum.com/showthread...hreadid=345877

--

Dave Peterson