Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Project days allocation (better mail format) | Excel Worksheet Functions | |||
Project days allocation | Excel Worksheet Functions | |||
find the beginning and end days of a project | New Users to Excel | |||
Calculate number days + hours to complete a project | Excel Worksheet Functions | |||
Greater than 5 days formula | Excel Worksheet Functions |