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.
|