S
shriil
I have a database for tracking equipment under outage as given below.
The basic data for each row is linked from other worksheets in the
workbook, where each worksheet pertains to an individual equipment.
The data which gets populated under the Final Sheet is not necessarily
in a sorted order as per the Item_Out Time.. It may look like
Equipment Out DateTime IN DateTime
Out_Hrs
MILL_GRP_1E 14/06/2010 10:10 16/06/2010
18:00 55:50
MILL_GRP_1D 28/05/2010 11:21 08/06/2010
14:35 267:14
MILL_GRP_1A 07/06/2010 12:03 12/06/2010
18:00 125:57
MILL_GRP_1C 31/05/2010 12:00 12/06/2010
17:00 293:00
MILL_GRP_1B 06/06/2010 10:46 07/06/2010
13:10 26:24
MILL_GRP_1B 12/06/2010 15:17 13/06/2010
6:03 14:46
MILL_GRP_1D 06/06/2010 20:30 06/06/2010
23:00 02:30
MILL_GRP_1C 09/06/2010 14:15 11/06/2010
9:21 43:06
MILL_GRP_1B 15/06/2010 13:13 16/06/2010
14:30 25:17
Would like to know how to Sort the table on Out_date_time through a
code or a macro where it checks the range of filled-up data that are
being populated and then executes the Sort.
Thks for the help
The basic data for each row is linked from other worksheets in the
workbook, where each worksheet pertains to an individual equipment.
The data which gets populated under the Final Sheet is not necessarily
in a sorted order as per the Item_Out Time.. It may look like
Equipment Out DateTime IN DateTime
Out_Hrs
MILL_GRP_1E 14/06/2010 10:10 16/06/2010
18:00 55:50
MILL_GRP_1D 28/05/2010 11:21 08/06/2010
14:35 267:14
MILL_GRP_1A 07/06/2010 12:03 12/06/2010
18:00 125:57
MILL_GRP_1C 31/05/2010 12:00 12/06/2010
17:00 293:00
MILL_GRP_1B 06/06/2010 10:46 07/06/2010
13:10 26:24
MILL_GRP_1B 12/06/2010 15:17 13/06/2010
6:03 14:46
MILL_GRP_1D 06/06/2010 20:30 06/06/2010
23:00 02:30
MILL_GRP_1C 09/06/2010 14:15 11/06/2010
9:21 43:06
MILL_GRP_1B 15/06/2010 13:13 16/06/2010
14:30 25:17
Would like to know how to Sort the table on Out_date_time through a
code or a macro where it checks the range of filled-up data that are
being populated and then executes the Sort.
Thks for the help