Group rows (or hide rows) like in MS Project
 

I do wish I could persuade all colleagues to use Project, but hey-ho, Excel
is more widely used.

I have therefore created a project plan in Excel. I have tasks, sub-tasks
and sub-sub-tasks, etc. I need to be able to produce a high-level report for
my director (tasks), a lower level for my line manager (sub tasks), and a
detailed plan for the practitioners (sub-sub-tasks, etc) - and I don't want
to have to do three plans.

In Project I can, at the click of a button, show each task level separately.
But how can I do this in Excel?

I created a macro which hid rows at a click, and another to unhide, but this
only works if you don't add any further rows - and I need to be able to add
rows. Also it looked rather clumsy.

I have all of the TASK ID numbers in one column (1.0, 1.1, 1.1.1, etc) and
all of the TASK NAMES in another column, as you would in Project. In the
TASK NAME column I have indented the lower levels accordingly.

Any help would be appreciated.

Group rows (or hide rows) like in MS Project
 

Have a look at DataGroup and Outline.

Might be you can do what you want.

Or try a Pivot Table

The macro to hide rows should work if you use a dynamic range instead of a
hard-coded range.

Then the insertion of rows would be picked up.


Gord Dibben MS Excel MVP

On Fri, 16 Oct 2009 12:14:02 -0700, Annie1904
wrote:

I do wish I could persuade all colleagues to use Project, but hey-ho, Excel
is more widely used.

I have therefore created a project plan in Excel. I have tasks, sub-tasks
and sub-sub-tasks, etc. I need to be able to produce a high-level report for
my director (tasks), a lower level for my line manager (sub tasks), and a
detailed plan for the practitioners (sub-sub-tasks, etc) - and I don't want
to have to do three plans.

In Project I can, at the click of a button, show each task level separately.
But how can I do this in Excel?

I created a macro which hid rows at a click, and another to unhide, but this
only works if you don't add any further rows - and I need to be able to add
rows. Also it looked rather clumsy.

I have all of the TASK ID numbers in one column (1.0, 1.1, 1.1.1, etc) and
all of the TASK NAMES in another column, as you would in Project. In the
TASK NAME column I have indented the lower levels accordingly.

Any help would be appreciated.

Group rows (or hide rows) like in MS Project
 

Hi,

You can group rows/columns. To group rows, say A10:A18, highlight A10:A18
and then press Alt+Shift+Right arrow

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Annie1904" wrote in message
...
I do wish I could persuade all colleagues to use Project, but hey-ho,
Excel
is more widely used.

I have therefore created a project plan in Excel. I have tasks, sub-tasks
and sub-sub-tasks, etc. I need to be able to produce a high-level report
for
my director (tasks), a lower level for my line manager (sub tasks), and a
detailed plan for the practitioners (sub-sub-tasks, etc) - and I don't
want
to have to do three plans.

In Project I can, at the click of a button, show each task level
separately.
But how can I do this in Excel?

I created a macro which hid rows at a click, and another to unhide, but
this
only works if you don't add any further rows - and I need to be able to
add
rows. Also it looked rather clumsy.

I have all of the TASK ID numbers in one column (1.0, 1.1, 1.1.1, etc) and
all of the TASK NAMES in another column, as you would in Project. In the
TASK NAME column I have indented the lower levels accordingly.

Any help would be appreciated.