Sorting a dynamic database table

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Overlaps 3
Calculation of Overlap Outage Hours 17
Suming Up Time over the course of days 1
Using AVERAGEIFS to calculate average rating for programs-Reposted (wasunclear) 0
Find then highlight in yellow 6
Calculating Work Time 7
Cumulative Timesheet Calculations 0
Multiple Creteria Lookup(Between Dates) 8

Top