Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Keeping the outline when copying a project to Excel
- Thread starter Ateles
- Start date
Yes.
1. In Project, along with all the data you are already copying, also copy the Project column "Outline Level".
2. In Excel (after pasting all the information including the Outline Level) click on Data | Filter | AutoFilter to turn AutoFilter on.
3. Click on the downward pointing triangle at the top of the Outline Level column in Excel.
4. Choose the highest number (let's assume 6). This will display the tasks that have the most indentation.
5a. Select all the task names that are displayed.
5b. Click on the Excel "Increase Indent" button 5 times.
6. Repeat for (in this case) levels 5, 4, 3, and 2 and click on the "Increase Indent" button 4, 3, 2 and 1 times.
It sounds a bit cumbersome but works quite quickly. Takes me 5-10 seconds per indent level.
1. In Project, along with all the data you are already copying, also copy the Project column "Outline Level".
2. In Excel (after pasting all the information including the Outline Level) click on Data | Filter | AutoFilter to turn AutoFilter on.
3. Click on the downward pointing triangle at the top of the Outline Level column in Excel.
4. Choose the highest number (let's assume 6). This will display the tasks that have the most indentation.
5a. Select all the task names that are displayed.
5b. Click on the Excel "Increase Indent" button 5 times.
6. Repeat for (in this case) levels 5, 4, 3, and 2 and click on the "Increase Indent" button 4, 3, 2 and 1 times.
It sounds a bit cumbersome but works quite quickly. Takes me 5-10 seconds per indent level.
- Status
Similar threads
- Locked
- Question