Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excel inventory control 1

Status
Not open for further replies.

copeco

Technical User
Joined
Jun 11, 2002
Messages
31
Location
US
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..
 
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.
 
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
 
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
 
rcopeco@yahoo.com
Thanks much Mike.......
 
Mike,
WoW!! Thanks so much for the help. That's exactly what was needed. I wish I had your skills....thanks
 
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.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top