Re: $$Excel-Macros$$ Dynamic Range for Pivot

=OFFSET($A$1,0,0,COUNTA(A:A),3) Thanks & regards, www.MrExcel4U.com On Mon, Mar 10, 2014 at 3:12 PM, Prafull Jadhav wrote: > Dear All, > > Good Afternoon, > > I want a examples of Dynamic Range of Pivot. > for example > if i added new data in master file then n

$$Excel-Macros$$ Dynamic Range for Pivot

Dear All, Good Afternoon, I want a examples of Dynamic Range of Pivot. for example if i added new data in master file then new rows or data should be added in pivot or suppose i delete the data thane range should be adjust accordingly Thanks in Advance. Regards, Prafull Jadhav 9920553518 -- Ar

$$Excel-Macros$$ Dynamic range for pivot table

I am trying to create a pivot table on a new sheet names as 4x4 I am getting following error: Error : 1004 Reference Not Valid I am not sure where is the problem. I have genererated this code by using macro recorder and just changed the source and destination of the pivot generation code. Need