Columns are vertical, rows are horizontal.

Which do you want?

"Pages" is what?

Multiple sheets or multiple areas on one sheet?

Filters don't work on multiple sheets.

A better description could help us to help you.


Gord Dibben MS Excel MVP

On Wed, 11 Jul 2007 16:34:02 -0700, Luke wrote:

I need to know how to create a filter that will tell me what a total is on a
horizontal column over multiple pages.