I was hoping somebody would be able to help me get started on converting some excel formula into VBA. I have a spreadsheet that is updated from various other workbooks with usage data on a daily basis. This is done via a vba button. What I would like is for this button to also update the moving average for each line. I have wrote the formula for this, but would really like to consolidate into one cell that is updated for each line. Problem is I dont know where to start to convert this.
Please see attached sample sheet
Thanks