Hi all

I have a master workbook which runs a macro/ VBA code every 5 mins or so and captures/consolidates call entries (data) tracked in individual excel workbook files.

The Macro works fine but I am faced with one problem

The data is nothing but calls tracked by different team members , when the macro runs it first captures data from say team member "Caren" then from team member "Anne" and its here that problem lies since I wanted to look at this consolidated data in a sorted format ( first by date and then by time)

Ideally this can be done manually but when we look at the fact that the macro runs every 5 mins its not feasible to manually sort data every 5 mins.

Is it possible to add a VBscript so that whenever the macro runs it also automatically sort the data (First by Date and then by Time)

Enclosing sample of the master file ( has been modified to protect confidentiality )

Thanks in advance

Due to server issues with VBA express I am unable to upload the sample file - I'll do so shortly