Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
time selection
Hi,
I have 4 spreadsheets in my workbook called "master","1", "2", and "3". In column K of the "master" sheet, the cell format is 'dd h:mm:ss'. How do i write a macro that would go through that column....if it's less than 5 hrs then move the row (from colum A to K) to sheet "1"...if it's between 5hrs and 24 hrs then move that row to sheet "2" and if it's more than 24 hrs then move to sheet "3"... the macro will keep on doing that until there is a blank line... thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving selection right one column at a time: Is there a shortcut? | New Users to Excel | |||
Selection.sort Run-time error '1004' | Excel Programming | |||
Adding time selection to pop-up calendar | Excel Programming | |||
Moving Range Selection Right One Column at a Time | Excel Programming | |||
Moving Selection and Time based run macro | Excel Programming |