i want to fix marvinp's code for Updating PivotTable filters based on other cell valu

Hi All

Can any one help me to fix the below mentioned programme in my excel sheet where i need this to work. i mean if any one can make me to understand this will be helpfull. i don't know the VB but i have the same requirement in my report what this programme does.

this is Mr. Marvin P's programme if he is seeing this thread please help me.

' CHANGES THE NAME IN THE CUSTOMER CONTACTS PIVOT TABLE

Dim pvtTable As PivotTable
Dim pvtField As PivotField
Dim pvtItem As PivotItem
Dim filterName As String

Set pvtTable = Worksheets("Contacts").PivotTables("PivotTable10")
Set pvtField = pvtTable.PivotFields("Opportunity Owner: Full Name")

filterName = Worksheets("Data").Range("B1")

For Each pvtItem In pvtField.PivotItems
If pvtItem.Value = filterName Then
pvtField.CurrentPage = filterName
Exit For
End If
Next pvtItem

thank you Arlette,

My requirement is. i have pivote table report which shows the project details. and i have a summarry where i can see the project details in summarry, now if i give the project Number in Summarry report and if i click the link it will teke me to the pivote table where i can find the details of the project but this report filter the project number should get change with the project number what i am entering in Summarry.

i don't understand what exactly you are saying

Hi All , i want to use if function with the cell content text, here i can't change the cell format because it is being taken from sql server and it will keep change every time when i update; so please help me to fix this problem i have attached the samply file for both my earlier query as well this question.

Originally Posted by ahmedkin

i don't understand what exactly you are saying

As this thread is getting messy, I will close it.

Please read forum rules before starting new threads and use code tags as requested by a senior member.