G Guest Jul 12, 2007 #1 I need to know how to create a filter that will tell me what a total is on a horizontal column over multiple pages.
I need to know how to create a filter that will tell me what a total is on a horizontal column over multiple pages.
G Gord Dibben Jul 12, 2007 #2 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
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