Hi Vba Gurus,
I have an Attendance application that feeds data dynamically of users
in our office to an excel sheet named input.(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
---
---
##############################################################
Now i want to update another sheet in same excel workbook named output
based on the above input.

- A button when clicked in this output sheet,Should process the input
worksheet and give me two sections
- Users those are in the building with latest in time and latest location
- Users those who are outside the building with latest out time and exit
point