I am using Excel 2000.

I have created a exam score tracking sheet and I want to be able to display
the most recent exam average once the new scores have been entered. The only
thing I can come up with is changing my formula to reflect the proper cell
after it populates. I am trying to figure out a way to have Excel do this
automatically. If anyone has any ideas I would greatly appreciate them.

Thanks.