Assigning a macro to ALL cells in a column in table with undefined number of rows

[Ohmie]

Hi,

I am new to this forum. I manage to use excel to maintain a database manually. New data is added everyday. Each day a new row is added. I know how to write a formula that calculates the average for a set of row data (for each row). I would like to write a macro for the value in the last column (The column for average) so that the avrage is calculated automatically as I add data for each day. Any suggestions, pointers, reference to sources would be greatly appreciated. Thank you.

[Ron Coderre]

Please post a workbook with some sample data and the results you want to see (based on that data). Otherwise, we'll just be guessing at what you're working with.

[Ohmie]

OK. So here is a table example
Date Val1 Val2 Val3 Val4 Val5 Average
9/1/2014 56 72 100 45 68.25
9/2/2014 75 86 88
9/3/2014 92 120 78
9/4/2014 110 84

As you can see, there are null values in some cells. The Average function gives me the correct result as shown in row # 1.
What I would like to accomplish is to have a macro for the Average Column so that the value is calculated automatically as new values
are added incrementally to each column as the date column continues down. The values will be entered each day.

Hope this clarifies my question. Thank you.