Trasnsposing or copying filtered data from one sheet to another
 

I have a top level summary sheet which I would like to show the
filtered data from the underlying sheets. I would like this done
automatically so that as I filter sheet 2, 3 etc, the top "summary"
sheet shows all this information automatically in the column I would
like them to appear.

Is this possible?? Thanks...

Transsposing or copying filtered data from one sheet to another
 

I figured out a way to do this with a macro. But it's a bit
cumbersum. Is there no function that will allow this to do it
automatically?

Thanks


On Thu, 12 Jan 2006 19:00:51 -0500, Sierras
wrote:

I have a top level summary sheet which I would like to show the
filtered data from the underlying sheets. I would like this done
automatically so that as I filter sheet 2, 3 etc, the top "summary"
sheet shows all this information automatically in the column I would
like them to appear.

Is this possible?? Thanks...