Hi ,

I am very much new to macro in MS xls .I am using 2003 version.
My requirement is :
Project.xls
A B C D
1 12 Closed 12/12/12 Code is completed.
2 15 Open 12/01/12 Analysis in Progress.

Suppose a report is generated from some tool and as in the above example A is the id number .B is status,D is comments and C is the date which gets updated when someone comments in the tool.

Now for n number of records. if any date in column C does not have todays(the present day) date , then I want some columns of those records to be copied into a new worksheet.

Can someone please help me in this .

Thanks
Keerthi