| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting the current month using a macro on a pivot table
I have a macro set to run every day. In the pivot table it chooses Nov. How
can I get this to choose the current month so that I don't have to change it every month. Also can make the change to current month on the 5th business day to the current month? ActiveSheet.PivotTables("PivotTable2").AddFields ColumnFields:= _ "MKT_REGION_NAME " With ActiveSheet.PivotTables("PivotTable2").PivotFields ("NOV") .Orientation = xlDataField .Caption = "Sum of NOV" .Function = xlSum |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Selecting the current month using a macro on a pivot table
just replace
"NOV" with UCase(WorksheetFunction.Text(Now, "mmm")) -- Gary's Student "Newbee" wrote: I have a macro set to run every day. In the pivot table it chooses Nov. How can I get this to choose the current month so that I don't have to change it every month. Also can make the change to current month on the 5th business day to the current month? ActiveSheet.PivotTables("PivotTable2").AddFields ColumnFields:= _ "MKT_REGION_NAME " With ActiveSheet.PivotTables("PivotTable2").PivotFields ("NOV") .Orientation = xlDataField .Caption = "Sum of NOV" .Function = xlSum |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Selecting the current month using a macro on a pivot table
Thank you!
"Gary''s Student" wrote: just replace "NOV" with UCase(WorksheetFunction.Text(Now, "mmm")) -- Gary's Student "Newbee" wrote: I have a macro set to run every day. In the pivot table it chooses Nov. How can I get this to choose the current month so that I don't have to change it every month. Also can make the change to current month on the 5th business day to the current month? ActiveSheet.PivotTables("PivotTable2").AddFields ColumnFields:= _ "MKT_REGION_NAME " With ActiveSheet.PivotTables("PivotTable2").PivotFields ("NOV") .Orientation = xlDataField .Caption = "Sum of NOV" .Function = xlSum |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Selecting the current month using a macro on a pivot table
You are very Welcome !
-- Gary's Student "Newbee" wrote: Thank you! "Gary''s Student" wrote: just replace "NOV" with UCase(WorksheetFunction.Text(Now, "mmm")) -- Gary's Student "Newbee" wrote: I have a macro set to run every day. In the pivot table it chooses Nov. How can I get this to choose the current month so that I don't have to change it every month. Also can make the change to current month on the 5th business day to the current month? ActiveSheet.PivotTables("PivotTable2").AddFields ColumnFields:= _ "MKT_REGION_NAME " With ActiveSheet.PivotTables("PivotTable2").PivotFields ("NOV") .Orientation = xlDataField .Caption = "Sum of NOV" .Function = xlSum |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count only if another column has data in Pivot Table? | Excel Worksheet Functions | |||
| How to show month end balances in a Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
| Macro to change a Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table with Zero Values for Month | Charts and Charting in Excel | |||
Linear Mode
