Would you be able to send me the file
Yes, would be happy to.
How do attach a file to this message? Is there an alternate method for sending the file?
Ok go to http://www.wikisend.com/ and upload the file using the Browse button (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.
If the file has sensitive information let me know before you upload it
Please find the download link below.
On sheet1, there is a redbox whose value can be changed with a droplist selection. When changed, the new value is meant to automatically update the pivot table based on the filter for group.
http://wikisend.com/download/173792/Update Pivot Table example.xlsm
By the way, there is no sensitive information in the file.
Ok Peter here you go
The macro fires automatically when a selection is made in cell G3. The code is in Sheet1 module
Hope this is ok. Thank you for rating this answer "Excellent" or "Good" if I was able to answer your question (will continue to assist after rating if you still need help)
I'm stepping out now to take kids to a movie. Will check file out when I return. Thank you for your help thus far!
Ok will wait until you get back. Please don't forget to rate, that is the only way I get paid for my work.
Enjoy the movie...