Experts,

I need help in following

I have 35 Sales persons. each sales person assigned 8-10 dealer for daily visit.

All sales person confirm their dealer visit reports daily through phone call. I need to collect this data and make report on monthly basis.

In this report I need to present Sales person's dealer visits and not visited.

How can i maintain this in excel.

Thanks for help in advance.