I've got a chart in Sheet 1, based on data in Sheet2. I have an autofilter applied to my data on Sheet2 to change the view in Sheet 1. I want my users, who can only see Sheet 1, to have the ability to choose a selection on Sheet1 which works the autofilter on Sheet2. The Autofilter field name is "Division", and it's in cell G1 on Sheet2.

Thanks in advance for your help.

Thanks,
John