I'm working on automating data analysis & creation of pivots and charts for which I have Raw Data (441379 Rows, 40 columns).
1) Raw Data keeps changing monthly, so I need a dynamic range.
2) I have to create around 20 Pivot Tables with the same data.
3) As of now I'm defining range...
First post to the forum, hoping someone can help me with this issue. I have searched the web for hours and also this forum and can't seem to locate the solution but apologies if I've overlooked it somewhere.
I accept that it is probably a relatively basic question but I am fairly...
I am creating a dashboard and need to be able to update multiple pivotcharts using a date range that comes from daily dates but is then grouped by month so that I can choose the month and year from a cells that are set up as data validation lists in two seperate cells and have the pivot table...
I have an excel model that contains several pivot tables across several worksheets. On the first worksheet of my workbook (called "Summary"), I have a drop down list where the user can select a Text value from several choices. The pivot tables that I've developed in the other worksheets...
I made a macro to perform certain filtering actions on a PivotTable, but now I want to use a cell value to make the macro filter on a specific month, so that I don't have to adapt the macro each month.
I thought this would be very simple, but I've tried several ways and I got...
I am making a quite large macro to create a pivot table where the user selects the items to sort and make a sum of these:
Dim Pt As PivotTable
Dim Sortering As String
Dim Forstevalg As String
Dim Andetvalg As String
'Change to the sheet with data
I have two PivotTabled in one Excel 2007 worksheet; it is required the PivotTables are side-by-side (horizontally next to each other).
The left-most PIVOT has a column that holds months; I use the date filter on this column to only show "This Month" or "Last Month" data. As a result...