I apologize if this is a dumb question, I'm just not that great with Excel. But I'm hoping to get better.
I'm currently trying to automate part of a process I do for my job that involves copying data from a pivot table and pasting it into another worksheet. However, the pivot table is setup to show cost data by month and each month the previous months costs get added to the pivot, and that's the data I need to copy. Only the most recent month. But I keep having the issue where the macro wants to copy the same column of data each time and not the most recent one. Is there a way to do this like I need?
Also, is there a way to account for additional rows showing in the pivot? For example, if there are 10 cost categories in the rows and then next month there are 12, can a macro be setup to capture all of the cost categories regardless of how many there are?
I'm currently trying to automate part of a process I do for my job that involves copying data from a pivot table and pasting it into another worksheet. However, the pivot table is setup to show cost data by month and each month the previous months costs get added to the pivot, and that's the data I need to copy. Only the most recent month. But I keep having the issue where the macro wants to copy the same column of data each time and not the most recent one. Is there a way to do this like I need?
Also, is there a way to account for additional rows showing in the pivot? For example, if there are 10 cost categories in the rows and then next month there are 12, can a macro be setup to capture all of the cost categories regardless of how many there are?