I do a number of reports with Microsoft Excel 2000 and subtotals.

At the top of each page, there are the "boxes", "2" gives you the
subtotal view, and "3" gives you all the data.

I run the subtotal on "department number", so the "2" page looks
something like this:

10 Total 200
20 Total 480
30 Total 900
Grand Total 1580

I want to bring down the group name in column b, so the "2" page looks
like this:

10 Total bikes 200
20 Total clothes 480
30 Total food 900
Grand Total 1580

I have been copying and pasting the group name manually for each group.
This example has only three groups, but mine has many more, making it a
tedious
process.

Is there a way to get the subtotals to do this automatically?

Maybe someone has some visual basic code that does this?

Thank you in advance for your help.

Collapse the outlining to just the subtotals.
Select those cells that need to contain the value above.
edit|goto|special|click visible cells only.

if the activecell is B23, then type =b22 and hit ctrl-enter.

The selected area--just those visible cells will contain formulas that point at
the cell above.

You could expand the outlining and convert column B to values (edit|copy,
edit|pastespecial|values).

wrote:

I do a number of reports with Microsoft Excel 2000 and subtotals.

At the top of each page, there are the "boxes", "2" gives you the
subtotal view, and "3" gives you all the data.

I run the subtotal on "department number", so the "2" page looks
something like this:

10 Total 200
20 Total 480
30 Total 900
Grand Total 1580

I want to bring down the group name in column b, so the "2" page looks
like this:

10 Total bikes 200
20 Total clothes 480
30 Total food 900
Grand Total 1580

I have been copying and pasting the group name manually for each group.
This example has only three groups, but mine has many more, making it a
tedious
process.

Is there a way to get the subtotals to do this automatically?

Maybe someone has some visual basic code that does this?

Thank you in advance for your help.

--

Dave Peterson