I have a worksheet which keeps up with personnel assignments. Column "C" has employee names, column "E" has employees days off in the format "M/T", T'W" etc. Cell G2 has the Now() formula which puts the current date in, and cell G3 has the day of the week. Column F is where the "Status" for the day goes; "8" for working, "V" for vacation, "RDO" for regular days off, etc.
I would like to know how to write VBA code to check an employees days off and if one of the days off is the current day of the week, then "RDO" would automatically be placed in column F. I assume it would have to be a worksheet change event? Maybe?

Hi

The Change event fires whenever there is a change in the worksheet. How often you want this to be updated - daily basis?

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Yes,
The two cells I mentioned (G3 and G2) update with the correct date and day of the week when the workbook is opened. The workbook is used every day. I am just trying to make it easy on the user so they don't have to put in RDO for the people who are off today! The subroutine should also color the background of the whole line, from column 2 to column 6, a yellow color when RDO is placed in column F.
Is this possible?

I would like this to happen when the workbook is opened, that way, the people who are off today there would appear "RDO" in their status column "F".