VBA code or formula to list all possibilities

[cidfidou]

Hi Excel Masters,

I would like to be able to list all the possibilities in a column of the following :

- If I have a qity of X in A1, I would like to be able to create a serie of possibilities of this qty to be dispacthed in A2 and A3 in column A as per below example... This will have to be working even with qty >0 in A2 and A3

Example

Starting position is 2 in A1 and 0 in A2 and A3 , and i would need those 2 to be sent to A3 and A4 and so on depending on X in A1 with all possibilities in the same column as below..

Any help would be greatly appreciated... Thanks in advance

Before MACro or Formula

A1	2
A2	0
A3	0

<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>

After MACro or Formula

A1	2
A2	0
A3	0
A4	1
A5	1
A6	0
A7	0
A8	1
A9	1
A10	0
A11	0
A12	2
A13	0
A14	2
A15	0

<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>

 

[cidfidou]

Any help on the above? is my pb well explained?