Autofilter hides totals I want to see

[Mark]

Hello everyone,

I am using Excel2000. I have a file in which I track
attendance at various activities. My autofilters work
fine, depending on which information I wish to display.
But at the bottom of my list, I display totals for how
many people were present / absent for each day (each of
which is represented in its own column).

Whenever I have an autofilter on for a column in which my
sub-totals DO NOT appear, they are still hidden. As an
example, when a member quits I put a special code in
column A. But this person may have attended some days
before quitting so I must retain him in the file, I
cannot delete his record.

To produce a current list, I use a custom filter in
Column A "not equal" to my special code. This works OK,
but my totals (where the attendance totals for each week
are) do not appear even though there is no active filter
on the columns in question.

Any ideas?

 

[Arvi Laanemets]

Hi

Set totals into header.

 

[Tom Ogilvy]

You should separate your subtotal by at least one blank row from you data.
then they should not be included in the autofilter.

When you apply the autofilter, only select you data or select a single cell
in your data, don't select the whole work sheet or whole column.

 

[Mark]

Hi Tom,

The totals were already separated, it must have been how
I had selected the filter. I chose a single cell as you
suggested, and all is well. Many thanks

 

[Shishir Ramam]

Hi,
If I am writing a macro, does it matter whether the
selected cell is a part of the eventual filtered output?

I seem to be getting two "Areas" when using
Range("A1").Select
Selection.AutoFilter ...

This seems to happen on the repeated (second and higher)
application of the AutofFilter command on the raw data
in a worksheet.

My problem is to the multiple areas that are coming back
from the autofilter command.

All help is much appreciated.
thanks,
-shishir