spaz9876
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
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