Excel 2000 VBA Subtotals help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I am using Microsoft Excel 2000 and Windows 2000.

I have created code to do subtotals on unique values on column A.

It then creates subtotals on unique values on column C.

I would like to put code in that breaks out the values for
specific values on column A. When it is done, I want it
to indent and show all the unique values for column C,
but keep their plus signs, so that the endusers can click on them,
if they choose. There are only *two* unique codes on column A that
I need to do this to.

It would really be a big plus if I can do this with code with the
computer's help. I have a number of reports that I am doing this to
manually.

Thank you in advance for your help.

.

Relevant Pages

  • Microsoft Excel 2000 Subtotals with Group Name
    ... I do a number of reports with Microsoft Excel 2000 and subtotals. ... Maybe someone has some visual basic code that does this? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Complicated Challenge
    ... Since you'll be preparing the reports (not the doofuss managers who'll get ... John A 1/19/05 ... You can remove the subtotals with Data - Subtotals - Remove. ...
    (microsoft.public.excel.misc)
  • How to Manipulate the group and sorting in a report?
    ... I want to create some reports, with filters that the user can select the ... sorting and grouping in a form. ... Subtotals o secondary sort? ... 2- Group by User AND Client ...
    (microsoft.public.access.forms)
  • Re: SQL reporting services - issues
    ... Explicitly set style properties on ... > better chance if you post to the .reportingsvcs newsgroup. ... >> i've been making for some time now a series of reports in reporting ... >> when using matrixes in reports, the subtotals come in very handy, ...
    (microsoft.public.sqlserver.tools)
  • Copy Certain Values
    ... I have 2 files where I generate reports for others. ... sheets for certain cells containing matching criteria. ... I would like to pick up the subtotals as values and sum them ... pick up the cell I need using the Offset line. ...
    (microsoft.public.excel.programming)