Thank you both for the help.

"David Biddulph" wrote:

If you have a link that says =Sheet1!A1, change it to
=IF(Sheet1!A1="","",Sheet1!A1)
--
David Biddulph

"Walt" wrote in message
...
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