View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Refresh pivot chart when info in a cell changes

To all,

I am looking for help with a Macro. What I ultimately want to do is refresh
a pivot chart when the user makes a selection from a list (in a data
validation cell). For example, I am an end user that selects my territory
from a "drop down". The pivot chart will update to the information that is
directly related to my territory. Thanks in advance for your help.