I am using a spreadsheet to compile monthly results for my company. Some of
these results are a YTD status measurement that uses the results from the
most recently completed month. Is there a way to have the YTD cell refer to
the most recently entered cell in a row?