I have included a link to a workbook in which the master worksheet contains a
column with a list of tasks, and then has 2 columns for each month (one for
the due date and one for the date completed).
The following worksheets are for various departments. They each have
different tasks, but all of the tasks can be found on the master worksheet.
What I need is some way to have the €œdate completed€� cells on the master
sheet automatically entered once that task has been completed on all of the
worksheets that contain that task.
I inherited this workbook that is used to track the compliance of various
departments throughout our site, so it is likely to have additions. It can
be reformatted as necessary.
THANKS SO MUCH!!

http://www.mediafire.com/?cvlymtxdjlg