$$Excel-Macros$$ Vba code for pivot table drill down and renaming sheet

Hi All, Need your help in pivot table drill down. I am having huge excel database around 15 rows having whole data of different accounts. I want to create a pivot on it on basis of Account No. and Amount which is located in column K and F respectively. After pivot table is created with

Re: $$Excel-Macros$$ Vba code for pivot table drill down and renaming sheet

Please attach File, I know how to handle new look. 2013/5/27 KAUSHIK SAVLA savla.kaus...@gmail.com Hi All, Need your help in pivot table drill down. I am having huge excel database around 15 rows having whole data of different accounts. I want to create a pivot on it on basis of

Re: $$Excel-Macros$$ Vba code for pivot table drill down and renaming sheet

Hi, Please find attached sample file. Instructions:- 1. I want to create Pivot Table based on data in Sheet 1 (range A3 to L1048576 In Row Label : Account In Values : Sum of Amount 2. I want to have drill down of every account one by one in different sheet and to rename the sheet with account

Fwd: Re: $$Excel-Macros$$ Vba code for pivot table drill down and renaming sheet

Hi team, Awaiting for response in below query. Appreciate your help in looking into it. Regards, Kaushik -- Forwarded message -- From: KAUSHIK SAVLA savla.kaus...@gmail.com Date: May 27, 2013 8:42 PM Subject: Re: $$Excel-Macros$$ Vba code for pivot table drill down and renaming