I have an xls spreadsheet that contains a list of user names and when they
log onto the VPN and when they log off the VPN.

This xls spreadsheets contains 37,000 rows of information. However this
includes all deparments, and I only need to do a report on the Accounting &
Land Department.

Currently I go through the xls sheet and delete all the usernames that do
not fall into the Accounting & Land department. This is tedious and time
consuming.

I would like to be able to enter all the usernames that I need to delete
into a macro or VB. Then that way I could run the macro, all the usernames I
don't need would be deleted and then I could start gathering information for
my reports each month.

Can somebody please help or point me in the correct direction, that is if
this is possible?