I need to average a column of numbers in a Table (of varying sizes) that contains data taken on various tests. The number data points of each test may vary from case to case. Data for different tests are separated by an empty row. The relative position of the start point is known but the number of columns to include is not known beforehand. This macro will run automatically based on a comparison of values in a different column as the data are accumulated.