Completing Data / Interpolation

[Marty96]

Hi All,

I am new to this forum.
I have a file containing monthly data. Sometimes my datafile does not contain monthly data but quaterly or sometimes points are just missing. I am trying to write VBA code to complete missing data points. For example, in the example file, in the column smoothed data, I would like to have the original data (if present) or otherwise have an interpolation between the adjacent points. In this case 183333 and 186667. Could you please help me out.

Thanks alot!Example Smoothed Data.xlsx

[Dave]

If your just inventing data, what's the point? Having typed that, seems like some kind of statistical thing could be used to find your mean and what that data point should have been... ie. provide the best guess of what your missing data should have been. I'm pretty sure no one understands "In this case 183333 and 186667" if U care to elaborate. Dave