Hello

I have quick question to ask i am getting stuck trying to do this in vba.

I have Column A that has many cell that different amount. I am trying duplicated this in vba with loop

Thanks

Loan Amount Loan Amount
1 12000 1 9999.99
2 50000 1 2000.01
3 35000 2 9999.99
4 8500 2 9999.99
2 9999.99
2 9999.99
2 9999.99
2 0.05
3 9999.99
3 9999.99
3 9999.99
3 5000.03
4 8500