Removing secondary entries
Hi Folks
Not the greatest expert on VBA/macro's so all assistance greatly welcomed.
I have a list consisting of events, the columns are:
Date, time, location, name.
This list can be dated anywhere between a couple of days and several weeks long.
Each user may appear several times on each date.
What i need to do is condense the list down is to show each user only once for each date. Additionally this is to be restricted to between certain hours. eg. 18:30 to 07:00.
Any suggestions and advice would be much appreciated.
Sample file attached.
|