L
Lobster
I'm looking for a specific calendar template for use with Excel 2003.
It's for use as a meeting planner, and what I want ideally is to be able
to have one worksheet displaying a standard calendar view something like
this one: http://tinyurl.com/bmnetp (OR
http://office.microsoft.com/en-us/templates/TC300041371033.aspx?CategoryID=CT102774121033&av=ZXL000
)
....where I can add an entry for a meeting into one date within a
displayed month, and that links to a row in a second worksheet within
the same workbook which contains details of all the meetings. That
worksheet would have columns for categories like "Date" "Time" "Title",
"Speaker", "Speaker invited Y/N?", "Speaker fee" etc etc
The cell in the 'calendar' worksheet would contain just "Speaker" and
"Title", say.
It would be easy to set up these as two entirely separate worksheets -
ie a 'calendar' one and a 'meeting details' one; and I could achieve
what I want by inserting manual links between the two, for every single
meeting, but it would be prohibitively fiddly and time-consuming: is
there an off-the-shelf solution?
Thanks
David
It's for use as a meeting planner, and what I want ideally is to be able
to have one worksheet displaying a standard calendar view something like
this one: http://tinyurl.com/bmnetp (OR
http://office.microsoft.com/en-us/templates/TC300041371033.aspx?CategoryID=CT102774121033&av=ZXL000
)
....where I can add an entry for a meeting into one date within a
displayed month, and that links to a row in a second worksheet within
the same workbook which contains details of all the meetings. That
worksheet would have columns for categories like "Date" "Time" "Title",
"Speaker", "Speaker invited Y/N?", "Speaker fee" etc etc
The cell in the 'calendar' worksheet would contain just "Speaker" and
"Title", say.
It would be easy to set up these as two entirely separate worksheets -
ie a 'calendar' one and a 'meeting details' one; and I could achieve
what I want by inserting manual links between the two, for every single
meeting, but it would be prohibitively fiddly and time-consuming: is
there an off-the-shelf solution?
Thanks
David