I have created spreadsheets to track baseball (MLB and College) and
basketball (NBA and college) records and standings. I would like be
able to track the record of a given set of games say the last 10
games. Is there a formula, function, macro or what ever to be able to
do this without manually updating the cell address?

any help would be greatly appreciated

JFE