I need some help and I'm not exactly sure where to post this.

I have over 100 customers and some of them need a delivery every week. Others need delivery every two weeks. Some, every three weeks and so on. We usually go to the same customer on the same day every week, depending on what date holidays fall. We have multiple trucks that make deliveries. What I need is to make sure a customer isn't skipped or forgotten. I want to be able to come in on a Monday and see the list of deliveries that are going out on Tuesday in Excel. If I see a customer listed for delivery, and we don't have an order, I want to be ale to contact them or the salesperson to find out why. How can I do this? If I have to make separate Excel files per truck, that's fine too.

Any help or ideas would be great. I'm very clueless with Macros and Visual Basic.

I'm using Excel 2007.