Hide rows if "0"
 

I have some data linked from spreadsheet B to spreadsheet A in the same
workbook. Sometimes the numbers show, sometimes they don't depending on the
results on spreadsheet B. Now I'd like to hide the rows automatically on
spreadsheet A if the result is "0". Is this possible at all, and if so - how.
Thanks in advance
--
Therese

Hide rows if "0"
 

Two possibilities. First, you can embed the link inside a formula to detect
a blank cell and replace it with a blank rather than bring back a 0: instead
of =SheetB!A1, use =if(isblank(SheetB!A1),"",SheetB!A1).
Second, you could simply use a filter. Select the table on sheet A. From
the menu bar, Data Filter Autofilter. Use the drop-down in the
appropriate column and select 'Custom'. Use the drop-downs in that dialog to
select 'does not equal' 0. When you click OK, those rows that had 0 in the
selected column will be hidden.
Is that what you're looking for? --Bruce

"Therese" wrote:

I have some data linked from spreadsheet B to spreadsheet A in the same
workbook. Sometimes the numbers show, sometimes they don't depending on the
results on spreadsheet B. Now I'd like to hide the rows automatically on
spreadsheet A if the result is "0". Is this possible at all, and if so - how.
Thanks in advance
--
Therese

Hide rows if "0"
 

HI Bruce-Thanks
I tried: if(SheetB!=0;"";SheetB!)(Don't know the"is blank-command" in
danish, so guess it's just like I wrote.) But it doesn't really help. I want
the things that aren't payed to show on sheet A, so there'll be a list. But
as the results on sheet B turns to "0", the numbers on Sheet A will
dissappear. But the list is long, and I just hoped there was a way for the
list to be shorter, so that the rows wich are empty would dissappear, or not
show. Guess it's just not possible to actually delete the rows.
But thanks - it works fine with the autofilter. :-)
--
Therese


"bpeltzer" skrev:

Two possibilities. First, you can embed the link inside a formula to detect
a blank cell and replace it with a blank rather than bring back a 0: instead
of =SheetB!A1, use =if(isblank(SheetB!A1),"",SheetB!A1).
Second, you could simply use a filter. Select the table on sheet A. From
the menu bar, Data Filter Autofilter. Use the drop-down in the
appropriate column and select 'Custom'. Use the drop-downs in that dialog to
select 'does not equal' 0. When you click OK, those rows that had 0 in the
selected column will be hidden.
Is that what you're looking for? --Bruce

"Therese" wrote:

I have some data linked from spreadsheet B to spreadsheet A in the same
workbook. Sometimes the numbers show, sometimes they don't depending on the
results on spreadsheet B. Now I'd like to hide the rows automatically on
spreadsheet A if the result is "0". Is this possible at all, and if so - how.
Thanks in advance
--
Therese

Hide rows if "0"
 

Hey Bruce: Perfect!! :-)
--
Therese


"bpeltzer" skrev:

Two possibilities. First, you can embed the link inside a formula to detect
a blank cell and replace it with a blank rather than bring back a 0: instead
of =SheetB!A1, use =if(isblank(SheetB!A1),"",SheetB!A1).
Second, you could simply use a filter. Select the table on sheet A. From
the menu bar, Data Filter Autofilter. Use the drop-down in the
appropriate column and select 'Custom'. Use the drop-downs in that dialog to
select 'does not equal' 0. When you click OK, those rows that had 0 in the
selected column will be hidden.
Is that what you're looking for? --Bruce

"Therese" wrote:

I have some data linked from spreadsheet B to spreadsheet A in the same
workbook. Sometimes the numbers show, sometimes they don't depending on the
results on spreadsheet B. Now I'd like to hide the rows automatically on
spreadsheet A if the result is "0". Is this possible at all, and if so - how.
Thanks in advance
--
Therese