Moving data automatically on the same sheet

[JDB]

Hi,

I have a workbook that tracks sickness absence. One of the columns is a
return to work date (either actual or anticipated). Is it possible that when
the return work column (column N) has a date in it that the row gets moved to
the top of the sheet so eventually all those with return to work dates will
be grouped together?

Regards,

JDB

 

[Max]

One simple formulas play which will autosort it in chrono order in an
adjacent range

Assume you have 3 cols of source data in cols A to C, data from row2 down,
where col C is the key col which contains the RTW dates (assumed to be real
dates)

In E2: =IF(C2="","",C2+ROW()/10^10)
Leave E1 blank

In F2:
=IF(ROWS($1:1)>COUNT($E:$E),"",INDEX(A:A,MATCH(SMALL($E:$E,ROWS($1:1)),$E:$E,0)))
Copy F2 to H2. Select E2:H2, copy down to cover the max expected extent of
source data, say down to H100. Minimize/hide away col E. Format col H as
dates. Cols F to H will return the desired autosort of the source cols A to C
in chrono order by RTW dates.