HELP!!! TIME SENSITIVE

  • Thread starter Thread starter Walt
  • Start date Start date
W

Walt

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.
 
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
 
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.
 
If you have a link that says =Sheet1!A1, change it to
=IF(Sheet1!A1="","",Sheet1!A1)
 
Back
Top