Hi!
I'm sure this question has been asked before, but I've searched and worded it different ways and coming up blank.
I'm trying to make one of the templates my team uses as easy and quick as possible. One of the things we have to do is paste in a data extract (all will have the same columns (13) but different number of rows) and refresh a pivot that's on a different sheet. The "shell" of the pivot table is already created. Right now, we go through the steps of changing the data source and refreshing, but it'd be nice to be able to just click a button and have it done, especially if some people aren't super Excel savvy.
How do I do this with VBA? I I'm just having a hard time with the bit to find the bottom of the data each time.
I'm sure it's super simple. Thanks so much!!!
I'm sure this question has been asked before, but I've searched and worded it different ways and coming up blank.
I'm trying to make one of the templates my team uses as easy and quick as possible. One of the things we have to do is paste in a data extract (all will have the same columns (13) but different number of rows) and refresh a pivot that's on a different sheet. The "shell" of the pivot table is already created. Right now, we go through the steps of changing the data source and refreshing, but it'd be nice to be able to just click a button and have it done, especially if some people aren't super Excel savvy.
How do I do this with VBA? I I'm just having a hard time with the bit to find the bottom of the data each time.
I'm sure it's super simple. Thanks so much!!!