software

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 quot;summaryquot;
sheet shows all this information automatically in the column I would
like them to appear.

Is this possible?? Thanks...

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?

ThanksOn Thu, 12 Jan 2006 19:00:51 -0500, Sierras gt;
wrote:

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