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