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

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

Perhaps I'm misunderstanding what you want to do, but can't you just
copy the worksheet several times and then set up whatever filter
conditions you require in each sheet?

Hope this helps.

Pete

On Sep 22, 4:25*pm, 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

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

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

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