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

Copyin the greater than 15 days project rows from one sheet to ano
 

This easy formulas play will autocopy the sub-list of projects as desired

In "15daysProjects",

Put in A3:
=IF(WeeklyReport!AT3-WeeklyReport!AS315,ROWS($1:1),"")

Put in B3:
=IF(ROWS($1:1)COUNT($A$3:$A$100),"",INDEX(WeeklyR eport!AN$3:AN$101,SMALL($A$3:$A$100,ROWS($1:1))))
Copy B3 to H3. Select A3:H3, copy down. Format cols G & H as dates.
Hide/minimize col A. Cols B to H will return the required sub-list of
projects, with all lines neatly packed at the top.

voila? high-five it here, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Max" wrote:
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

Copyin the greater than 15 days project rows from one sheet to
 

Dear Max,
Thanks a lot for your inputs, i have not tried as i am on vacation
I had another query here
From AN3 till AT100 i have used coloring for cells based on groups of
systems under which these projects fall,
IF i want to be able to move the data to "15daysProjects" retaining the
same color how can i do this, please suggest
Thanks
max
"Max" wrote:

This easy formulas play will autocopy the sub-list of projects as desired

In "15daysProjects",

Put in A3:
=IF(WeeklyReport!AT3-WeeklyReport!AS315,ROWS($1:1),"")

Put in B3:
=IF(ROWS($1:1)COUNT($A$3:$A$100),"",INDEX(WeeklyR eport!AN$3:AN$101,SMALL($A$3:$A$100,ROWS($1:1))))
Copy B3 to H3. Select A3:H3, copy down. Format cols G & H as dates.
Hide/minimize col A. Cols B to H will return the required sub-list of
projects, with all lines neatly packed at the top.

voila? high-five it here, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Max" wrote:
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

Copyin the greater than 15 days project rows from one sheet to
 

Downstream differentiation based on manually applied cell fillcolors, I don't
know, and its something I never practise, sorry.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Max" wrote:
Dear Max,
Thanks a lot for your inputs, i have not tried as i am on vacation
I had another query here
From AN3 till AT100 i have used coloring for cells based on groups of
systems under which these projects fall,
IF i want to be able to move the data to "15daysProjects" retaining the
same color how can i do this, please suggest
Thanks
max