I need to assign a macro to a button which can update ALL my pivot table and 'Month' to the previous month data. For example: If i click that button on 5th February the pivot table updates the data for January month (as the data is reported monthly).
not sure if the file attach will work as the pivot is connected a external data source.
not sure if the file attach will work as the pivot is connected a external data source.