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 help me out.
Thanks in advance
Keshav
Bookmarks