Hi
Please Help!
I am trying to write a VBA Excel macro that looks at a large set of data and is able to interpolate between values that only appear every 125 rows or so (this being the tricky bit!).
What I need to be able to do is count the number of empty cells between two cells with values in, and then fill in these cells by interpolating based on the start and end values.
The problem I have is that the values are not always 125 rows apart, sometimes they are 123,124,125,126,127. The column length is ~40,000 cells hence the need for a macro!!
So, I need a way of automating the finding the first start and end value cells, calculating the number of non-value cells between these, interpolating, and then moving down (through some loop) to next start and end point.
Any ideas or thoughts much appreciated!!!
Please Help!
I am trying to write a VBA Excel macro that looks at a large set of data and is able to interpolate between values that only appear every 125 rows or so (this being the tricky bit!).
What I need to be able to do is count the number of empty cells between two cells with values in, and then fill in these cells by interpolating based on the start and end values.
The problem I have is that the values are not always 125 rows apart, sometimes they are 123,124,125,126,127. The column length is ~40,000 cells hence the need for a macro!!
So, I need a way of automating the finding the first start and end value cells, calculating the number of non-value cells between these, interpolating, and then moving down (through some loop) to next start and end point.
Any ideas or thoughts much appreciated!!!