steviemac_uk
New Member
- Joined
- Sep 22, 2017
- Messages
- 3
I've been wrecking my brains at this one for a while now, I'm a complete newb to Excel so if you can bear with me that would be great. If you can help, that would be awesome. Right, if you look at the image labelled "stock control" you'll see a formula in C2. The same formula is used all the way down the that column and is triggered by the presence of a 1 in Parties!B3 times the number of participant in Parties!B5 in the other image labelled, Parties. Now, I need to replicate this across the parties tab, B3:BI3 and B17:BI17. The background is, the sheet is set out to help manage stock with reference to children's parties and ingredients used per party. I want to be able to input a children's party, e.g. package one, Parties!B3, then the number of participants, Parties!B5 and then calculate how much ingredients have been used D2*PartiesB5 then subtract that from the input level of stock B2 to give me what stock I should have left C2. I worked out the formula of how to do that for one cell, Parties!B3 but have no idea how to get it to give me those figures across multiple cells. So, if I have several Children's parties I want to know how much stock I have left so I can replenish. In a nut shell, inputting a 1 in Parties!B3 will change the values in C2:C18. How do I get it so that when I input a 1 in Parties!C3 and so on, to also change the values in C2:C18 to reflect how much stock is left? I hope you followed that..lol.
Steven.
