Macro to divide a range and insert them in new rows equally

Hi,

I have set of datas as seen below.


DATE OPEN HIGH LOW CLOSE
13-Jan-14 1165 1200 1165 1185
13-Jan-14 1165 1175 1165 1175
13-Jan-14 1175 1185 1175 1185
13-Jan-14 1185 1195 1185 1195
13-Jan-14 1195 1200 1190 1190
13-Jan-14 1190 1190 1185 1185

The Second row starts with 13-jan-2014 is a OHLC values of a particular stock.Now i want to calculate the range(high-low) of the particular day.
Then the range has to be divided into 10 per row.

Here

The second row has a range of (1200-1165)=35 points.Close is greater than open,So the stock has closed with up trend.
so i have divided 35 by 10.The last row is left with 5 points short.It has to be considered with next day's data.And this process goes like a loop.It would be great if an expert can solve the issue.

13-Jan-14 1165 1200 1165 1185 (Original row,Needs to be divided by 10)
13-Jan-14 1165 1175 1165 1175
13-Jan-14 1175 1185 1175 1185
13-Jan-14 1185 1195 1185 1195
13-Jan-14 1195 1200 1195 1195 (This is short of 5 points to reach 10,It has to be taken into account when next day opens)

Regards,

Netaji

Thanks for your reply Venkatpvc.I have attached the sheet for review.