Prev: pulling random data from another tab in spreadsheet?
Next: Multiple conditions using greater than or less than.
From: Joel on 9 Mar 2010 14:44 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.
From: Herbert Seidenberg on 9 Mar 2010 23:22
Excel 2007, PivotTable With Table dependent drop-downs instead of data validation drop-downs. With non-event-driven macros. http://www.mediafire.com/file/ygzjqyi2j1x/03_09_10.xlsm |