show filter criteria
 

I have data in numerous worksheets in a workbook that I am summarizing
in another worksheet. Each worksheet can be filtered. On the summary
sheet, I need to show how each worksheet is filtered. Is this
possible?


--
slechols
------------------------------------------------------------------------
slechols's Profile: http://www.excelforum.com/member.php...o&userid=21237
View this thread: http://www.excelforum.com/showthread...hreadid=399222

show filter criteria
 

On Thu, 25 Aug 2005 14:25:44 -0500, slechols
wrote:


I have data in numerous worksheets in a workbook that I am summarizing
in another worksheet. Each worksheet can be filtered. On the summary
sheet, I need to show how each worksheet is filtered. Is this
possible?

You might find the following of some use

http://www.j-walk.com/ss/excel/usertips/tip044.htm

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

show filter criteria
 

Maybe Stephen Bullen's code at John Walkenbach's site will help:
http://j-walk.com/ss/excel/usertips/tip044.htm

slechols wrote:

I have data in numerous worksheets in a workbook that I am summarizing
in another worksheet. Each worksheet can be filtered. On the summary
sheet, I need to show how each worksheet is filtered. Is this
possible?

--
slechols
------------------------------------------------------------------------
slechols's Profile: http://www.excelforum.com/member.php...o&userid=21237
View this thread: http://www.excelforum.com/showthread...hreadid=399222

--

Dave Peterson

show filter criteria
 

Oops. I didn't realize your post was a reply.

Richard Buttrey wrote:

On Thu, 25 Aug 2005 14:25:44 -0500, slechols
wrote:


I have data in numerous worksheets in a workbook that I am summarizing
in another worksheet. Each worksheet can be filtered. On the summary
sheet, I need to show how each worksheet is filtered. Is this
possible?

You might find the following of some use

http://www.j-walk.com/ss/excel/usertips/tip044.htm

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

--

Dave Peterson