excel inventory control 1

[copeco]

Good morning.

I have a list of part#s with quantities next to them. I want to be able to go to say sheet2(the list is on sheet1) and be able to key in a part# and add or subtract a quantity from that part# and the results show on sheet1. eg(part# _________ qty____(+ or -))
thanks..

 

[Hasit]

Hmmm, interesting one, but from your description, I am not sure that the whole capability would be available, because if you are subtracting a number in one cell in sheet 2 from another in sheet 1, then the cell in sheet 1 would need to have some sort of formula. This would make it a circular reference.

You would need to have a base set of numbers from which to subtract from (or add to) to get the running total of the stock item.

The rest of your requirements are reasonably simple to implement.

If you can show a couple of columns with some sample data in your post back, then I can put together a few formulas for you to try out.

 

[copeco]

thank you..
Here is an example..
this is on sheet1:
part# qty
abc 23
def 45
ghij 65

sheet2: part#: abc qty: -5 enter
sheet1 again:
abc 18
etc etc
this is to keep others away from the sheet1. So all they see on sheet2 is Enter part#________ Qty______
This can be added to or subtracted from.
.....Hope this helps...thanks again

 

[rmikesmith]

copeco,

I am putting together a demo workbook to do what you are asking. If you are still interested, post your email address and I'll forward this to you when ready.

Regards,
M. Smith

 

[copeco]

rcopeco@yahoo.com
Thanks much Mike.......

 

[copeco]

Mike,
WoW!! Thanks so much for the help. That's exactly what was needed. I wish I had your skills....thanks

 

[Hasit]

COPECO - firstly, I apologise for not getting back to you - work kinda took over. Secondly, I am pleased that someone else was able to help.