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 |
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 |