Hi guys
I've made a massive pivot table.. however i want all rows which is 0 in one column to be hidden. Is there a setting for this, or do I have to make a macro to go and hide all rows which has 0 in a certain column ?
Thansk
Hi guys
I've made a massive pivot table.. however i want all rows which is 0 in one column to be hidden. Is there a setting for this, or do I have to make a macro to go and hide all rows which has 0 in a certain column ?
Thansk
First enter this small macro:
Sub Macro1()
Dim r As Range
For Each r In Selection
If r.Value = 0 Then
r.EntireRow.Hidden = True
End If
Next
Then, in the pivot table, go to the column that may contain zeros and select
the cells you want to check.
Then run the macro
--
Gary''s Student
"Ctech" wrote:
>
> Hi guys
>
>
> I've made a massive pivot table.. however i want all rows which is 0 in
> one column to be hidden. Is there a setting for this, or do I have to
> make a macro to go and hide all rows which has 0 in a certain column ?
>
>
> Thansk
>
>
> --
> Ctech
>
>
> ------------------------------------------------------------------------
> Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
> View this thread: http://www.excelforum.com/showthread...hreadid=538405
>
>
Thanks Gary's Student
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks