show filter criteria

[slechols]

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?

[Richard Buttrey]

On Thu, 25 Aug 2005 14:25:44 -0500, slechols
<[email protected]> 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]

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

[Dave Peterson]

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

Richard Buttrey wrote:
>
> On Thu, 25 Aug 2005 14:25:44 -0500, slechols
> <[email protected]> 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