I keep getting a bunch of 0's in the empty cells. Is there a way to stop
that from happening? I have roughly 7 columns with over 700 rows.

"Gary''s Student" wrote:

Say the original is a table from A1 thru Z100 (with headers on the first row).

Copy the table. Go to the next blank worksheet and paste/special/link. The
new worksheet will have the same values as the original, but will be able to
be filtered on its own.
--
Gary''s Student - gsnu200805


"Walt" wrote:

Hi,

I have a worksheet that is filtered. I need to create multiply worksheets
that can show information based on the initial worksheet but with different
filters. Is that possible?

Thank you