Hi Vba Gurus,
Please see if you can help me in this.
I have an Attendance application that feeds data dynamically of users
in our office to an excel sheet named worksheet1.(Rows added on the fly.)

Example as Follows:-

"User_Name" "Time" "IN/OUT" "Location"

Jack 09:30 in 3rd floor Lobby
Joe 09:25 in 3rd Floor Lobby
Jill 07:25 in 5th floor Lobby
Sant 11:00 in 6th floor Gym
Jack 13:00 out 3rd floor Exit
Romi 08:00 in 5th floor lobby
Sushil 09:00 in 4th floor lobby
Joe 11:00 out 5th Floor exit
Romi 14:00 out 6th floor exit
Jack 14:50 in 3rd floor lobby
Joe 15:00 out somewhere
Jill 16:00 out somethingelse
Jack 17:00 out 4th floor exit
Sushil 18:00 out 6th floor exit
Jack 19:00 in 4th floor exit
Sant 20:00 in 6th floor Gym


---
---
################################################## ############
Now i want to know the latest (last) status of users based upon current
time to be updated in worksheet2.
This worksheet2 need to be updated as and when new rows are added in
input worksheet1.
OR
- A button when clicked in this worksheet2,Should process the input
worksheet1 and write to worksheet2.

########### Worksheet2 Sample output#######

INS
############################################

"User_Name" "Time" "IN/OUT" "Location"
Jack 19:00 in 4th floor exit
Sant 20:00 in 6th floor Gym

OUTS
################################################## ##
Joe 15:00 out somewhere
Jill 16:00 out somethingelse
Romi 14:00 out 6th floor exit
Sushil 18:00 out 6th floor exit