HI.
I having problems figuring out excel 2010
To specific. my ISSUE is this:

I have a survey list(oil well surveying) that goes some what like this:
Depth   INCLINATION   Azimuth   tvd    Northing   Easting
30    xxx             XX    xxx        xxx    xxx
60    xxx             xxx     xxx         xxxx         xxx
   
I have FORMULAS that will intepolate(find new values based on the known) every 5 meters between the survey stations(between 30 and 60) at for example depth 35,40,45,50,55. At this depths I will CALCULATE new incliantion, azimuth,tvd,Northing and Easting. I just dont know how to arrange this. The surveys are always taken every 30m/100ft. When I import the survey I would like excel to create automatically 4-5 cells in between the surveys stations(between 30 and 60) in the raws next to it. In these cells  I will have the formulas to calculate the interpolated figures. If any one has a better way of arranging this, I will be more than happy to hear.

for example:
Depth   inclination   Azimuth   tvd    Northing   Easting   Interpolated depth    inclination
30     xxx           xxxx            xx             xxx           xxx     
                                                                                                35                        xxx
                                                                                                45                        xxx
60              xxx          xxxx         xx            xxx           xxx