A
AUCP03
I have a workbook with two worksheets. The first worksheet has 9 columns of
data. As I am assigned new tasks I add rows to the first worksheet. The
second worksheet is a calandar of employees.The tasks have assigned due dates
which are input into column C of the first worksheet. The name of the
employee tasked with said item is in column B. I would like the workbook take
the due dates and the person associated with it and go to the second
worksheet, find the due date for the task and the associated person and
highlight it. Also when the item is closed or completed the first worksheet
column D is changed from Open to Closed. When this happens I would like
highlighting of the date on the calendar worksheet to go away.
Workbook
Worksheet#1 "Tasks"
9 columns of data
A "ID Code"
B "Person Assigned"
C "Due Date"
D "Status" (Open-means working on it Closed-means completed)
The rest of the columns are project specific descriptors
Worksheet#2 "Calendar"
The calendar is broken into months and the months follow underneath the
previous one. Each person has there own row. In each row Column A is there
name. Following them is the day of the month 1,2,3,...,31 (or however many
days there are) The values for 1,2,etc are acutally the entire date stored
as MM/DD/YYYY, but only displaying DD
So basically I want it to highlight the due date of the task from "Tasks" on
"Calendar" when the Status is Open and to not highlight it when the status is
closed.
Sorry that was so long. Thanks for any help.
data. As I am assigned new tasks I add rows to the first worksheet. The
second worksheet is a calandar of employees.The tasks have assigned due dates
which are input into column C of the first worksheet. The name of the
employee tasked with said item is in column B. I would like the workbook take
the due dates and the person associated with it and go to the second
worksheet, find the due date for the task and the associated person and
highlight it. Also when the item is closed or completed the first worksheet
column D is changed from Open to Closed. When this happens I would like
highlighting of the date on the calendar worksheet to go away.
Workbook
Worksheet#1 "Tasks"
9 columns of data
A "ID Code"
B "Person Assigned"
C "Due Date"
D "Status" (Open-means working on it Closed-means completed)
The rest of the columns are project specific descriptors
Worksheet#2 "Calendar"
The calendar is broken into months and the months follow underneath the
previous one. Each person has there own row. In each row Column A is there
name. Following them is the day of the month 1,2,3,...,31 (or however many
days there are) The values for 1,2,etc are acutally the entire date stored
as MM/DD/YYYY, but only displaying DD
So basically I want it to highlight the due date of the task from "Tasks" on
"Calendar" when the Status is Open and to not highlight it when the status is
closed.
Sorry that was so long. Thanks for any help.