HI visi,

See the attached workbook where yellow cell has the value to distribute and same are distributed over green cells using formulas.
values spilling.xlsx

Regards,
DILIPandey
<click on below * if this helps>