I'm trying to create a calendar in Excel. I need one each for 7 salesmen in
our organization. It must be set up like an appointment book. (I've found a
template that I can modify to work.) Each salesman will maintain his own
calendar on daily basis but our secretary needs access to all of the
salesmens calendars. Can I set up such a calendar and have all entries (from
each salesman) show up on another calendar that can be viewed by the
secretary. Maybe each salesman would have a different color font to
differientiate one from the other. If someone knows of such an animal that
doesn't cost a fortune I'd appreciate any information. Otherwise, I just
need to know if this is possible in Excel before I spend a lot of time on it
and find out it won't work. Thanks in advance for any help you might be able
to give.

I can tell you that it is possible. I don't know of any place with such a
piece that is currently available. It will require a fairly indepth
knowledge of VBA. I personally would go about it by having the secretaries
calendar be the master calendar and then from there send out the basic format
to your sales people for them to update. The secretary would be able to hit
a button that would open the sales calendars and then select the information
in the cells for that sales person and append each to master sheet. Through
hacking around on an idea like that someone with a pretty good understanding
of VBA could put something like that together.

"jwj" wrote:

I'm trying to create a calendar in Excel. I need one each for 7 salesmen in
our organization. It must be set up like an appointment book. (I've found a
template that I can modify to work.) Each salesman will maintain his own
calendar on daily basis but our secretary needs access to all of the
salesmens calendars. Can I set up such a calendar and have all entries (from
each salesman) show up on another calendar that can be viewed by the
secretary. Maybe each salesman would have a different color font to
differientiate one from the other. If someone knows of such an animal that
doesn't cost a fortune I'd appreciate any information. Otherwise, I just
need to know if this is possible in Excel before I spend a lot of time on it
and find out it won't work. Thanks in advance for any help you might be able
to give.