I'm sorry to ask such a broad question, but I'm unsure of what excel and VBA is really capable of (a lot, I'm beginning to learn).

I have a few hundred travelers that I need to track - dates, flights, rental cars etc. I can do this with a simple excel sheet, but dates overlap, some can't go until others get back, etc. etc. I also have cost info to input, etc. It can get confusing. I have an access databasse, but it's too basic - I need something visual (perhaps something that would include the travelers photo too - though it's not necessary). Is there a way to get an interactive style calendar in Excel using VBA? If not, can anyone recmmend any other types of software I may be able to look at?

Thanks!

J