Moving data automatically on the same sheet
 

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

Moving data automatically on the same sheet
 

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?