Adding 5 rows after each row and automaticallly populating them

[jwalkerack]

Hi i guys . i am hoping you might be able to help me .

I have a data set of 300 points and i want to increase my data range by a factor of 10 .

For example if i have Column A with master points A1=10 A2 = 20 A3 = 30 .

I would like to be able to automatically enter in the same about of new rows between each point . Then calculate there difference between the master points and populate the new rows in sequence . For example The difference between A1 and A2 = 10. So the new A2 would be 11

i would like to have A1=10 A2=11 A3= 12 A3=14 Etc as the new cells

I m not sure if this is possible . But any help would be great

Thanks a lot

 

[kevatarvind]

Hi And Welcome to The Board

Can you Post Some Sample of your data with Desired Result ?