trying to push remaining figure if less than 0 to another box titled spare

[mrmrvr88]

Hi Everybody new to this and a bit of a beginner.
I am trying to make a table to help with distribution of new jackets to staff in different branches.
if you look at the attached excel sheet you will see that i have different branches with info of chefs names how many they need then further info at bottom of individual tables of trying to figure out numbers needed minus stock in use currently. iam am still collecting actual data for the tables but have hit upon a problem in the bottom calculations. If we look at St Helens table (F88) we can see i require 2 XL jackets but have 10 XL jackets in stock (F89) this brings up a total of -8 in (F90) what i would like is a formula or a macro that would run along the line of (totals needed to buy) upto in this case (G90) to enter the value of 0 if none needed, however if over ie. the remaining 8 it would push this remainder figure to the spare box (H81) so as i can then see easily what spares i have to distribute. However then it gets further confusing as im wondering if there is a way to actually write some sort of macro that would recognise the size of these remainder values as in the box (F80) and add this to the box (H82)?

like i said i am a bit of a beginner to this so there may be a much easier solution that im not seeing but as this is just the start of this sheet and it will be used a lot in future i thought i would ask for some help and advise.

Thank you in advance and sorry if i have made it all sound more complicated than it is.

[JeteMc]

Hello mrmrvr88 and Welcome to Excel Forum.
Perhaps the following will help.
For the 'Totals needed to buy' rows (modeled in row 90) use: =MAX(0,B88-B89)
Put the 'Spare' row underneath each segment (row 91) and populate using: =MAX(B89-B88,0)
This should make it easy to see which size jackets are listed.
You could then total all of the spares (row 106) using: =SUMIFS(B5:B105,$A5:$A105,$A106)
Let us know if you have any questions.