If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
HELP!!! TIME SENSITIVE
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 |
#2
|
|||
|
|||
HELP!!! TIME SENSITIVE
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 |
#3
|
|||
|
|||
HELP!!! TIME SENSITIVE
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 |
#4
|
|||
|
|||
HELP!!! TIME SENSITIVE
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 |
#5
|
|||
|
|||
HELP!!! TIME SENSITIVE
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 |
#6
|
|||
|
|||
HELP!!! TIME SENSITIVE
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 |
Thread Tools | |
Display Modes | |
|
|