I wish I got day off too......here is heavy snowing.....

should I upload a file here???

no! email me la. u don't want to post anything work related in public especially you are with the govt.

LOL.....I can delete all the content and change to something else.....

anyway, I try to explain here....

1st sheet is the master.....A3 will updated auto daily

and when the dates in Colume D less than A3, the word will changed and the whole row will highlighted....

and I want this highlighed row some of the cells can auto update in different sheet that for either printout / email weekly to manager

so u have two conditions: 1) dates in column D >= A3. 2) dates in column D < A3.  Correct?

The other sheet (call it the report sheet), do you need to print it when it is in condition 1?

what are u talking about the 1 & 2????

1) column D < A3-1
2) =column d < A3

some of the cells from sheet 1 auto pop in other sheet when it's in condition 2 which I update in previous post

do u look or use the report sheet at all when condition is not 2?