i have 40 weekly sheets, and on each weeks sheet we will list the last
section completed.

I will need to move that information forward though the sheets if no new
entry is made.

if new entries are continually made, are or made sometimes ( like in the
case of absenties ) I will need move the last entry forward.

with the last entry always on a total sheet

looking for a formula that can do this
--
thanks dwight