ethomas0521
New Member
- Joined
- Feb 23, 2016
- Messages
- 11
HI All,
I have written a pretty extensive macro but I am unfortunately stuck at a part back in the beginning.
The issue I have is that the macro needs to allow for the user to select where 4 separate pivot tables are coming from automatically.
Right now the only solution I have is a command prompt that requires the user to go to the particular worksheet the pivot is coming from and select the range manually, for each pivot.
I need help automating this. So the macro will select a particular range on a worksheet to update the data source for all 4 pivots.
Pleas help!
I have written a pretty extensive macro but I am unfortunately stuck at a part back in the beginning.
The issue I have is that the macro needs to allow for the user to select where 4 separate pivot tables are coming from automatically.
Right now the only solution I have is a command prompt that requires the user to go to the particular worksheet the pivot is coming from and select the range manually, for each pivot.
I need help automating this. So the macro will select a particular range on a worksheet to update the data source for all 4 pivots.
Pleas help!
