View Full Version : Pasting Links Part 2

07-01-2005, 12:41 PM
I created a sheet that links a quantity column to another sheet within the same workbook (so I can hide the one sheet with confidential information).
The links work but it shows a "0" in every cell that is blank on the confidential sheet. I want to be able to filter by "non blanks" as I have headings that I put a"." in so they show up. I used a Custom Format (per mdmackillop on here) 0.00;-0.00;""

Now I have an issue with this.... some of the cells we want to put a character in so that it shows up in the filter but when we do this, it changes the other column to "#VALUE!" We used to use "0" but now that the linked tab hides the "0s" in order for the link to not show "0s" all the way down the column, we can't use them anymore to show optional items.
Qty Unit Price Extended Price
1 $130 $130
0 $925 $ -
O $25 Value

07-06-2005, 10:37 AM
Hi Spaz

Did you try using the changing your option not to accept zero value. On the toolbar choose Tools--Options , choose the view tab and remove the check mark beside "Zero Values"

Hope it help