Hi,
I am fairly proficient at excel but I never seemed to be able to do anything VBA. In one of my spreadsheets, I have a dropdown and when you select a new option in the dropdown, everything in the worksheet automatically updates except for my pivot tables. I need to refresh all every time a new selection is made.
Is it possible to write a macro that "refresh all" whenever a new selection is made in the dropdown? The dropdown is in cell A2.
Thanks for the help!
I am fairly proficient at excel but I never seemed to be able to do anything VBA. In one of my spreadsheets, I have a dropdown and when you select a new option in the dropdown, everything in the worksheet automatically updates except for my pivot tables. I need to refresh all every time a new selection is made.
Is it possible to write a macro that "refresh all" whenever a new selection is made in the dropdown? The dropdown is in cell A2.
Thanks for the help!