I have inherited an Excel spreadsheet from an engineer that has 4 pivot tables in it going against the same data set (same worksheet). Each has a drop-down listbox that is the same for each table. For the sheet to work correctly, you have to go and set each listbox to the same value separately.
I'd like to either run all of these off the same listbox, or run a macro that updates them all simultaneously. Am looking forward to your recommendations; thanks.