Hello Everyone!

I know to use excel for basic operations. But now I got a very complex request. Can someone help me on this. Basically the problem is I have a excel sheet like this

Username Date Time
XXX Thu 04/06/2017 10:45:01 AM
XXX Thu 04/06/2017 11:57:01 AM
XXX Thu 04/06/2017 10:57:01 AM
XXX Thu 04/06/2017 08:57:01 PM
XXX Thu 04/06/2017 09:57:01 PM
XXX Wed 04/05/2017 12:30:05 PM
XXX Wed 04/05/2017 06:30:05 AM
XXX Wed 04/05/2017 10:30:05 AM
XXX Wed 04/05/2017 11:30:05 PM
YYY Thu 04/06/2017 10:45:01 AM
YYY Thu 04/06/2017 11:57:01 AM
YYY Thu 04/06/2017 10:57:01 AM
ZZZ Thu 04/06/2017 08:57:01 PM
ZZZ Thu 04/06/2017 09:57:01 PM
ZZZ Wed 04/05/2017 12:30:05 PM
ZZZ Wed 04/05/2017 06:30:05 AM
YYY Wed 04/05/2017 10:30:05 AM
YYY Wed 04/05/2017 11:30:05 PM

I want to write a vbscript to extract data from this sheet and post the latest and oldest row to a new spate sheets based on the user Date and Time.

the output of recent sheet would be like mentioned below. i.e one row per user name for that day with time
Username Date Time
XXX Thu 04/06/2017 09:57:01 PM
XXX Wed 04/05/2017 12:30:05 PM
YYY Thu 04/06/2017 11:57:01 AM
YYY Wed 04/05/2017 11:30:05 PM
ZZZ Thu 04/06/2017 09:57:01 PM
ZZZ Wed 04/05/2017 12:30:05 PM

Likewise need to get the oldest row in a separate sheet like this
Username Date Time
XXX Thu 04/06/2017 10:45:01 AM
XXX Wed 04/05/2017 06:30:05 AM
YYY Thu 04/06/2017 10:45:01 AM
YYY Wed 04/05/2017 10:30:05 AM
ZZZ Thu 04/06/2017 08:57:01 PM
ZZZ Wed 04/05/2017 06:30:05 AM

Note: Both the sheets need to be sorted on username and date.

Thank You in Advance!!
-Jaga