move text forward if there is no new entry?

  • Thread starter Thread starter dwight
  • Start date Start date
D

dwight

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
 
One formulas idea, which pulls the last row of data over ...
Assuming the last row of data in each sheet is always fully populated
Assuming the 1st sheet is named: Sheet1
In Sheet2,
put something like this in A2:
=IF(ISNA(LOOKUP(2,1/(Sheet1!A2:A100<>""),Sheet1!A2:A100)),"",LOOKUP(2,1/(Sheet1!A2:A100<>""),Sheet1!A2:A100))
to extract the last row value in Sheet1's col A. Copy A2 across as far as
required. Repeat likewise for Sheet3, Sheet4, etc. You can use Edit>Replace
to quickly replace the sheetname: Sheet1 with Sheet2, etc. Modify the range
to suit. Any joy? hit YES below
 
Back
Top