Hi Message board!,
I have a requirement to sort data using Excel and I wondered if VBA would be able to assist me in the process.
My data is like this :-
Date Door Status OpCode Time Duration Traffic
01/09/2006 1 Open 20 07:00 0.20 2,010
01/09/2006 2 Open 22 07:04 0.05 1,033
01/09/2006 1 Closed 26 07:30 0.45 976
I need to be able to automatically look up the time difference Door one opening and closing and the total duration and traffic flowing through it.
The trigger to start counting is Opcode 20, the end trigger is Opcode 26.
Could anyone possibly help me?
Many thanks.
I have a requirement to sort data using Excel and I wondered if VBA would be able to assist me in the process.
My data is like this :-
Date Door Status OpCode Time Duration Traffic
01/09/2006 1 Open 20 07:00 0.20 2,010
01/09/2006 2 Open 22 07:04 0.05 1,033
01/09/2006 1 Closed 26 07:30 0.45 976
I need to be able to automatically look up the time difference Door one opening and closing and the total duration and traffic flowing through it.
The trigger to start counting is Opcode 20, the end trigger is Opcode 26.
Could anyone possibly help me?
Many thanks.