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(SMA LL($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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JDB" wrote:
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?