Creating a macro to add and subtract from a standing count

Hello. First off, I wanted to say that my knowledge of excel is very limited and I have nearly no experience with programming.

That being said, i'll try to explain what i'm trying to do.

I'm building a spreadsheet for work to better control a portion of our inventory and streamline workflow. We produce baked goods and ship nationally, so we can't allow our kitchen to bake a large amount....I just realized all of this is unnecessary information.

Anyways, please see the picture attached.

I'm trying to create a button where the black area is. The items in the "C" and " i " columns will be entered by a user. Items in the "C" column will be subtracted from items in the "F" column when the button is pressed, and items in the " i " column will be added to items in the "F" column when the button is pressed.

If someone is willing to help with this issue or to point me towards some easily understood how-tos, i'd be very grateful. thank you.

I agree with Teylyn. What you describe is feasible, but I think it's dangerous.

If I understand correctly, what you are trying to do is this. You have a stock at the beginning of the day, and during that day you add orders, and re-stock, and you want to keep track of the stock level.

I would do something along these lines: 1 sheet for the new orders received, where you list them as you receive them, 1 sheet where you list the restocking, and a 3rd sheet where you do the sum of orders received by item, orders restocked, and show that together with your initial stock.

My 2 cents!

Ha, i was actually going to ask for some advice on how to show a history of items added and subtracted, but I thought that would be too much for my first post. From the sounds of it, that would be a lot of information to type up for a new excel user. Do you know where I can find a good how-to for that type of work?

Thank you very much for the guide. I'll try to research the commands as much as possible before I come back here with a question. Thanks again, i'll let you know how it goes.

By the way, I saw you're from NZ. I just got back a little bit ago and this was one of the things I had on my list after my vacation. Mind if I ask where you're from? I spent a lot of time around Wanaka, Nelson and Whangarei with brief excursions in between. Not relevant to the help i'm asking for or the help you're providing, but I had to ask after checking to see who spent all that time showing me some excel tips.

Very nice. Dont believe i ever made it over there.


Is there any way i can email you a copy of the spreadsheet i'm working on? The one I posted was mainly just to convey the idea of what i was trying to do. The spreadsheet i'm working on doesn't have any sensitive data, I would just rather not post it on a forum.

I don't want to take up too much of your time, but maybe if you show me how to implement these formulas into a cell or two on my spreadsheet, it'll 'click' with me a little better.