View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 390
Default Copyin the greater than 15 days project rows from one sheet to ano

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