Thanks for the reply.
Have you tried the autofilter menu options?
I am going to.
I am writing the code so that it will auto filter to each name, then insert appropriate rows where there are missing dates. Then once that does its thing. I will just filter to only show "missing" -which I will also insert in column C for every newly inserted row.

If anyone has any better ideas let me know.