At first glance I would feel inclined to say that three tables would suffice:

Merchandisers
Stores
Appointments

Appointment can hold the date, time, merchandiser_id and store_id. Then between VB and any macros you can do the calculations. Just seems like a lot of info to be storing if it isn't necessary. Then again, today was perhaps the longest day of work I've had this year

Maybe I'll take a nap and look again