Looping Through Worksheet Finding Matching Data

[realniceguy5000]

Hello, I stuck on this problem, I have included a sample worksheet of what my data looks like (tab1)and what I would like the data to look like(tab2) tab 3 is just a reset in case the script messes up the data.

What I am trying to do is look at col A and B and if those same values are found later on down the list and the date is not the same as the one found, move the found time into the same col and row and delete the found values from col a , col b and the start time and stop time.

It is difficult to explain is why I included a spreadsheet to help. Here is the script I'm working with. It appears to work till a duplicate isn't found then it starts to mess up.

Thanks for any help, Mike

Please Login or Register  to view this content.

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

[realniceguy5000]

This should do the trick, Thanks so much for taking the time to help out...

Great work,
Mike

[AlphaFrog]

You're welcome. Thanks for the feedback.