Exponential Interpolation

[RRW119]

I have a large data set that requires periodic exponential interpolation. I know that a macro would really speed things up. Unfortunately, my skills are very limited at this point and I can only record and do minor editing. What I am wanting to accomplish with the macro I don't believe can be accomplished thru recording and then editing. I was hoping that someone might be able to assist me with the necessary code for the macro. My data sets have an x and y value. I would like to delete the y values I know that are incorrect by hand and then run a macro that identifies the last legitimate x and y value(i.e. not a blank) and then the next legitimate x and y value and then interpolates for all blank y values between these values using the following function to interpolate.

y =ya*(yb/ya)^[(x-xa)/(xb-xa)], xa<x<xb


The macro will need to do this procedure several times within the same column as there will be blanks spot throughout the worksheet for the y values. Is there anyone that can help me out with this?

[shg]

Post a workbook and explain in context.

[RRW119]

I have uploaded a workbook. In column A are the X values, column B the Y values of interest. In column C I applied the interpolation formula as an example. However, I am hoping that the macros will apply this for all blank values in column B. Please, let me know if you need more details. Thank you.