Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
moving data from one sheet to another | Excel Discussion (Misc queries) | |||
moving filtered data between worksheets automatically | Excel Worksheet Functions | |||
Moving data from one sheet to another automatically | Excel Discussion (Misc queries) | |||
Moving data from one sheet to another- How to? | Excel Worksheet Functions | |||
moving formula resupts to another sheet automatically | Excel Worksheet Functions |