Creating a new xls sheet from a existing one with certain columns.

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

Please attach your sample book. Go to advance-Attachment

Hi,

I have attached sample book .

Also i have attached the result sheet which i need.
(As the date in first record of sample_project.xls is not equal to todays date, some columns of that record should be copied into sample_result.xls )