I am new to VBA, but I know that a solution can exist for my issue. What I am trying to do is:
- prompt the user to select a pivot (from many) on the active worksheet
- prompt the user to select the field of the pivot they want to use (type in manually)
- prompt the user to select the field...