pivotable

i was try "Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???" how to possible Conditional Formatting ????

HOW TO USE REFERENCE WITH "RIGHT OR LEFT" FORMULA FUNCTION ???? EXAMPLE: i Try this Reference "AB156480" =+A2 But I need Output : " AB156-480" How it Possible After reference ????

How to Pull data One file to both file ???? I try to Pull data "Master" File To "Local" & "Export" File .......... I don't Know ???? How to possible .......Pleased send us Formula in excel..

Show Result : 3 (Pleased Show this Query........................................)

Hello Experts, Following is actual data and the common column in both sheets is "Style No.". The two sheets have thousands of records. Lets say first sheet is with prices and order quantity and the second sheet is with actual shipped quantity. TABLE 1 WITH PRICES...

I found a vba code that I copied on this forum that lopps through a slicer and selects / deselects each name and bring up the relevant data for that person and prints it. It works but for some reason it keeps creating prints about 104 pages when there are only 39 names in the slicer. The last...

Using VBA: My spreadsheet inserts the formula to copy data from another spreadsheet that will have been selected by the user and could be in a normal file system or sharepoint. I don't know how to automatically create a data connection which may sort this problem. I then force a Calculation...

I have total overdue amounts in Col E on my Pivottable I am trying to calculate the % per Item as a % of the total on Col E on the Pivotable, but it returns 0.00% =GETPIVOTDATA("Total Overdue ",$A$3,"Name","Sales")/SUM(OFFSET(E3,1,0,50000)) It would be appreciated if someone could...

I have a code it doesn't work correctly, please help me Sub addhideitems() Dim WSD As Worksheet Dim PTcache As PivotCache Dim PT As PivotTable Dim Prange As Range Dim Finalrow As Long Set WSD = Worksheets("sales") Dim WSR As Worksheet For Each PT In WSD.PivotTables PT.TableRange2.Clear Next PT...