Marty96
11-26-2014, 07:28 AM
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!12540
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!12540