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.
Bookmarks