Hi Guys,

I new to this forum, and am really in need of your help.
I have the following problem. I want to make an sliding scale macro starting from row 13 till last row.
For Example;

Scales
Scale 1 = 0-1000
Scale 2 = 1000 - 2000
Scale 3 = 2000 - 3000

Total amount A13 = 2500

Now I want the total amount go through the scales. And want to have an output as follow:

A13 = 2500 (the total amount)
B13 = 1000 (scale 1)
C13 = 1000 (scale 2)
D13 = 500 (scale 3)

Hope You Guys Can Help Me Out because I totally lost it

Kind regards