Hello Excel experts. I am one month into learning VBA code and syntax. I hit a wall. I want a macro that calculates the average difference between two rows in neighboring columns. More specifically after 21 lines/rows of the difference value I want the average to begin calculation. What I want is to display a moving average of this value and that is my problem. I do not want to create the moving average in another column. As time goes on the data set will get bigger rather quickly and creating a separate column just for the moving average will add unnecessary data to the growing file.
Thank you for reading. Thank you in advance for your thoughts and expertise