Hi all

I have a code with which reads the data from sheet 1 and creates a pivot table on sheet2. This code works. Now I want to copy some data from sheet1 to sheet4 and create the same pivot onto sheet2. This does not work! I get this error message Run Time Error 1004. I used F8 to run the code line by line, i get this error when i run the line below in the code starting with activeworkbook.pivotcaches.........etc

Please Login or Register  to view this content.
----------------------------------------------

Please help me out.

Thanks in advance
Keshav