How to auto fill values based on rule

Is it possible to have Excel automatically input data from the total to the 5 levels and 2 levels using the rules I have next to it? I've been trying to look into it for a while but I've had no luck, thanks for the help!