Need macro that calculates two formula but displays only one of them in column

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

Try this macro:

Please Login or Register  to view this content.

OK, I see the difference. Try this one:

Please Login or Register  to view this content.

There should be a better way to do it but at least it works.

OK, I see the difference. Try this one:

Please Login or Register  to view this content.

There should be a better way to do it but at least it works.