Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Macro
Hi,
I have two sheets in excel, sheet1 is the source data, where the count of the data keep changes. sheet2 is the pivot sheet, where pivot is allready created. I need a excel macro code, to update my pivot every day, when i run macro. Update means, As in sheet1 the count of row keep changing the macro first it should check the count in sheet1 then, the macro should update the same row count in pivot. Macro should do the changes in existing pivot, it should not create a new pivot. Please help me... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Macro
Hi
Instead of using a fixed range as the source for your PT, use a Dynamic range. InsertNameDefineName myData Refers to = Sheet1!$A$1:INDEX(Sheet1!$1:$65536,COUNTA(Sheet1!$ A:$A),COUNTA(Sheet1!$1:$1)) Then refer to the named range myData in your macro -- Regards Roger Govier "Ranjit kurian" wrote in message ... Hi, I have two sheets in excel, sheet1 is the source data, where the count of the data keep changes. sheet2 is the pivot sheet, where pivot is allready created. I need a excel macro code, to update my pivot every day, when i run macro. Update means, As in sheet1 the count of row keep changing the macro first it should check the count in sheet1 then, the macro should update the same row count in pivot. Macro should do the changes in existing pivot, it should not create a new pivot. Please help me... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Macro
Try the code below
copy and Paste the code in new module Option Explicit Sub ShowDates() Dim pt As PivotTable Dim ws As Worksheet Set ws = Worksheets("Pivot") Set pt = ws.PivotTables(1) pt.PivotCache.Refresh End Sub Vishwanath N *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro for a pivot | Excel Discussion (Misc queries) | |||
Pivot + Macro | Excel Programming | |||
Pivot...and macro. | Excel Programming | |||
Steps from Macro recorder for Pivot table will not run as a Macro | Excel Programming | |||
pivot macro | Excel Programming |