hello, I'm new to the site, and a fledgeling excel user. I can do basic stuff like simple formulas in cells, but I'm having a bit of trouble figuring out how to make formulas for what I want excel to do now. In a nutshell, I make ammunition for weapons of different calibers. On my first excel sheet, I have balances on hand for each type of bullet that I make, plus another column for the various raw materials that I also have on hand. On my second workbook sheet, I have "recipes" for each bullet. EX: one .45 cal bullet takes one .45 cal case, one .45 cal bullet, one large primer, and 6 grains of powder.
What I want excel to do is make a reusable form where I can just type in how many bullets I made. lets say I made 10 .45 cal bullets today. I want excel to subtract the components used to make the bullet from my materials balance while also adding the newly made bullets to my bullets on hand balance. And then tomorrow I can just type in that I made 25 more bullets, and it will automatically complete the rest of my workbook.
I'm willing to learn how to do this work on my own, as I love to learn new things. If someone could give me the basic idea and formulas and point me in the right direction I'd really appreciate it! I can also upload my file if anyone wants to look at it.
Thanks!
Bookmarks