Hello,

Im looking for a method in Excel to automatically fill in a range of cells
(column A), given a value for the step and an end value. The calculations in
the adjacent column (B) are based on column A. Consequently, the range in
column B should automatically be adjusted to that of A. In the example below,
column A goes from 0.5 to 1 in steps of 0.1. The values in column B are
calculated from column A. If I adjust the step to 0.05, column A becomes 2
times longer and B should adjust automatically.
Can somebody help me with this?
Thanks,
Maarten

Initial value: 0.5
Step: 0.1
End: 1

A B
0.5 A1/SUM(A1:A6)
0.6 A2/SUM(A1:A6)
0.7 A3/SUM(A1:A6)
0.8 A4/SUM(A1:A6)
0.9 A5/SUM(A1:A6)
1 A6/SUM(A1:A6)