Finding the difference between days and copying the data row to another sheet

I have a Workbook called Report which has 2 sheets in it. One is
"WeeklyReport" and the other sheet is ">15daysProjects".
Say i have header in AN2,AO2.....AT2 (i hv values of resources from Column
A till AM so started from AN). and from AN3 until AT100(not the limit) i have
project details

AS2 has header for start date and AT2 has header for End date i.e AS and AT
will have start and end dates in format "25-JUN-2009"(ex)

Now in sheet ">15daysProjects" i have to move those projects from sheet
"WeeklyReport" whose duration is more than 15 days. First we need to find out
the greater than 15 days project and then copy the necessary rows between AN3
and AT100 there.
How can i achieve this , please help

Thanks a lot in advance
max

try this macro . The spelling of sheet tabs and their mention in the macro should be exactly same

Please Login or Register  to view this content.