As Debra said, adding the Vlookup column to the source data for the Pivot
Tabel would solve the dynamic change problem without using an event macro.

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote:

create an adjacent column that uses the Vlookup worksheet formula.

If you want it to be dynamic as the user manipulates the pivot table
dropdowns, then you would have to write code to reapply the formulas although
I am not sure there is an event triggered when the pivot table selections are
made - so it might be delayed.

--
Regards,
Tom Ogilvy


"Hemant_india" wrote:

hi
it's tricky to explain my problem
but i'll try
1) i am pupolating a sheet with a text file which contains(sheet1)
2) some catagories in numeric form
e g 1 for apple 2 for bannana etc
3) i have a these descriptions on another sheet(sheet2)
4) with sheet1 i create a pivottable which contains these catagories in
colunms
i want to use data on sheet2 as list to correctly display the descriptions
of those catagories.
how am i to acieve this?

--
hemu