It works!!! Thanks Max.

The only problem encounter now is data "0" was captured at SubjectID column
on new sheet due to the empty cell at sheet X. Hence, I have to do a filter
to take out all the "0" data.

Overall, it make me save lots of time.


"Max" wrote:

Just to add that in the new sheet,
do format cols A and B as date and time to taste
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---