eversharp
08-13-2012, 09:32 AM
I have an Excel file that looks like this in Columns A, B, and C
1/1/2012 | $1.03 | Tool Type 7XA
1/4/2012 | $1.06 | Tool Type 7XA
1/8/2012 | $1.01 | Tool Type 7XA
1/9/2012 | $2.09 | Tool Type 7XA
I would like a Macro to insert the missing dates using the average of the date before and after them....
For example it would insert rows 1/2/2012 and 1/3/2012 with a price of $1.045 (the average of 1/1 and 1/4)
then it would insert 1/5, 1/6, and 1/7 with the average of the 1/4 and 1/8 prices... and so on.
Can anyone help with the syntax?
Thanks much!
1/1/2012 | $1.03 | Tool Type 7XA
1/4/2012 | $1.06 | Tool Type 7XA
1/8/2012 | $1.01 | Tool Type 7XA
1/9/2012 | $2.09 | Tool Type 7XA
I would like a Macro to insert the missing dates using the average of the date before and after them....
For example it would insert rows 1/2/2012 and 1/3/2012 with a price of $1.045 (the average of 1/1 and 1/4)
then it would insert 1/5, 1/6, and 1/7 with the average of the 1/4 and 1/8 prices... and so on.
Can anyone help with the syntax?
Thanks much!