Hi Everyone,
I am very new to VBA and not particularly skilled at it, but I have a set of data that is being continuously added to that I would like to get averages from. Overall, I have 184 rows of data, and for each one of these rows, I need to take the value of the cell in every 5th column (starting on cell B5), average them together, and have them pasted into a cell on another sheet. The number of rows I have and the locations of where the calculated averages were placed will never change, but the amount of numbers BEING AVERAGED, AKA the amount of columns I have, will increase over time, so I need the calculation to stop at the last filled cell and not continue to average empty cells in further columns. I'm not sure where to even begin on this, so any help is greatly appreciated. I know it's a little confusing, so if clarification is needed let me know. A screenshot of the data I'm looking to be averaged is below for some visual help. Thanks ahead of time!
Capture.PNG
Bookmarks