creating updated inventory

Not very good at excel but trying to learn. Your help is greatly appreciated. Thanks in advance. Trying to set up an ink inventory for a print shop. Multiple PMS ink colors used daily(e12-15 that can change) Need to update inventory (column B) and stay chaged after daily use. Would it be better to have Usage on different sheet (this is portion operators turn in daily). I also need to have sheet I can just put in PMS number and it will tell how much is on hand.

Hi philmozzz,

I think you should arrange your data as shown below:-

Date PMS Ink Used
10/1/2012 110 Black 1
10/14/2012 117 Cyan 1
10/5/2012 124 Magenta 4.5
10/14/2012 130 Yellow 13
10/14/2012 132 PMS 2.5
10/11/2012 133 301 5
10/5/2012 139 186 12
10/14/2012 144 264 5
10/1/2012 151 284 12

and then you can play around with sum and count function in you main inventory master list. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

You asked :-

Would it be better to have Usage on different sheet (this is portion operators turn in daily).

Hence, I have given you a better structure to follow which will help later for calculations.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

dilipandey is showing the correct way to structure data for a simple database. however that's not the question here I think.
You want a small database with userinterface. Something like this attached. Is this what you want?

philmozzz:
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Yeah I forgot to mention, it's just a mockup. Shouldn't be to hard to put some code to those buttons. Anyone wanna have a go?
If not I'll see if I can get something done in a day or so. It's kind of a generic problem so I'm hoping it will be useful for others too. And me of course.
Since the four basic colors are just four I figure they don't need a lookup, the list is right there.

Creating simple inventory database perhaps?