I have set aside the maximun number of rows in the table and have currently set them to zero.

I think I am looking for a function to go in the cells but really i am just looking for a way of getting the data in the cells so i can add em up.

The situation is that i am creating small investments based on cash on hand and am trying to work out the income. So the cash on hand allows up to 3 loans per month for a maximun numberof 36 months. So there could be 108 loans but there could also be 0 loans.

The numbers that i want to put in the rows are the loan returns per month (i know the value of that) and so I want a way of being able to create variable number of rows depending on that 0-3 number and to put the data in those rows - i think i can do that last part by use of index and column functions.

I hope that helps