HELP!!! TIME SENSITIVE

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
 
G

Gary''s Student

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.
 
P

Pete_UK

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
 
W

Walt

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.
 
D

David Biddulph

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need help on either doing a loop and counting specific values orusing subtotal function 2
Embed the same Excel multiple times 0
Sorting and filtering text 0
Wotksheets 0
Syncing between source worksheet and dependent worksheets 0
Automation of scanned file storage based on content 0
Code Snippet - Data Filter 10
Link a text box based on drop down box with four options MS Word 365 0

Top