Hi All,

Help would be really appreciated. Actually I have one pivot table on sheet which is having 2 page fields, Say one is Account Number and another field is Old Account Number.

Account Number field is having all the account numbers whereas Old Account Numbers is having Old Account Numbers associated with the Account Number field.
Now what i need whenever i select any Account Number from page field the other page field Old Account Number should get refreshed\updated automatically to show only those Old Account Numbers associated to Account Number field.

Basically i would like to update page field based on selection of another page field

How this can be done, if it requires VBA coding please advise as i am not really familiar with the VBA coding. Please not i am trying to achieve this in earlier version of excel i.e. in excel 2000 and in excel 2003

Thanks in advance!