View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
Chris Mitchell Chris Mitchell is offline
external usenet poster
 
Posts: 12
Default Can I copy Groups from one spreadsheet to another?

I have a file which has been produced by exporting data from MS Project, and
I would like to make this easier to read in Excel by grouping Tasks and
sub-Tasks by Row. I don't have MS Project myself, so am dependant on
exports by people who do.

If I manually Group Tasks and sub-Tasks by Row can I copy/transfer these
Groups to the next version I receive, or do I have to do the grouping all
over again from scratch?

There is a column headed 'Outline Level', containing numbers 1 to 8. Can
these be used to create an Outline in Excel? If so how?