I am looking into various ways I can use Excel 2003 to track
objectives/goals.

Plan:
One worksheet/workbook to display the Master Plan. Master Plan
includes all strategies for company (broad statements). Each strategy
needs to be assigned to a department (or multiple departments). From
there, the department(s) will come up with their own goals that help
work towards completing the Master Plan Strategies.

Problem:
Each department needs their own separate worksheets they can edit. The
worksheets need to show the Strategy and subsequent objectives/goals
for that strategy. A time line is needed (by month) that will display
in color the progress for this objective/goal) - Blue - no progress,
Green - on time, Yellow - behind schedule, Red - late, Gray - to show
time not working on item (future time through the due date).

All these items need to link to the MASTER PLAN so the General Manager
can have a snapshot view of all strategies / department progress
towards the strategies...

Any suggestions???

Tammy