On hand inventory sheet

[pclplante]

Ok, I have an order sheet that I let people order parts from. Now in this sheet I have a column that shows the on hand quanity. What I'm looking for is when a person orders a part, the on hand quanity updates with the new amount. Now for the tricky part, at the end of the day I clear the order sheet and hence need the on hand quanity to keep the new value so when the people open it back up tomorrow they can see what the new on hand quanity is. I can't insert the sheet but here is the break down.
A1 B1 C1 D1 E1 F1 G1 etc... Total On Hand
Item1 __ __ __ __ __ __ etc... 21
Item2 __ __ __ __ __ __ 50
Now when someone orders item1 for a parcticular position they put the quanity of item1's they want in their position b1 - g1 represent seats then the total on hand would update and I would fill the orders and clear out the form at the end of the day. Well that is it please help me here I'll check back later or you can email me @ Removed E-Mail Address - Moderator Thanks

 

[Smitty]

I did tweak you code and it doesn't seem to work. Maybe I don't know what I'm doing, I open the VB on the developer tab cut and pasted the code tweaked it to fit the range B6:AN98 and AO for the target column saved it and nothing when I put in some numbers on the sheet.

Sorry about that, looks like we just missed each other.

The code needs to go in the Worksheet specific module. Right-click the sheet tab and Select "View Code", then paste the ammended code in there. Note that you'll have to delete it if you have it anywhere else.

 

[pclplante]

Thanks it works fine. I really need to do an Excel camp or something. I have lots of books on excel but they are only for reference when I really get stuck I come here. A Big Thank You

 

[Smitty]

Anytime