sg2209
01-18-2019, 08:01 AM
Hi Friends,
I am new to VBA, learning by watching videos, reading forums, googled and taking help from Excel Forums.
i am facing an issue with the below code where from Sheet 1 data copied to sheet 2 and then it insert a new sheet and Pivot Table gets Created , there is another sheet with source data named Deepsee an another Pivots Created in another sheet 2 however every time Pivots name gets changed and macro for Pivot Table 2 does not work exactly as per requirements, Shall anyone please help me , below is the code :-
I am new to VBA, learning by watching videos, reading forums, googled and taking help from Excel Forums.
i am facing an issue with the below code where from Sheet 1 data copied to sheet 2 and then it insert a new sheet and Pivot Table gets Created , there is another sheet with source data named Deepsee an another Pivots Created in another sheet 2 however every time Pivots name gets changed and macro for Pivot Table 2 does not work exactly as per requirements, Shall anyone please help me , below is the code :-