I need the following expected output :-
Column A1 : 6
Column B1 : 3
Column C1 : 5
Answer A10 : 6
A11 : 5
A12 : 4
A13 : 3
A14 : 2
A15 : 1
A16 : 0
where it reach 0, the next column B17 : 3 will start as ( it take from the upper column B1 )
B17 : 3
B18 : 2
B19 : 1
B20 : 0
then the next column if still not null, then it will take value from C1 to start again. If C1 : 5, then it will be
C21 : 5
C22 : 4
C23 : 3
. .... till it goes to reach 0. It will start to fill as long as the upper column 1 filled with value.
How to code this is macro vb for easier data fill ?
Please help me. Thanks.
Regards,
Lim
Column A1 : 6
Column B1 : 3
Column C1 : 5
Answer A10 : 6
A11 : 5
A12 : 4
A13 : 3
A14 : 2
A15 : 1
A16 : 0
where it reach 0, the next column B17 : 3 will start as ( it take from the upper column B1 )
B17 : 3
B18 : 2
B19 : 1
B20 : 0
then the next column if still not null, then it will take value from C1 to start again. If C1 : 5, then it will be
C21 : 5
C22 : 4
C23 : 3
. .... till it goes to reach 0. It will start to fill as long as the upper column 1 filled with value.
How to code this is macro vb for easier data fill ?
Please help me. Thanks.
Regards,
Lim