I have a workbook with multiple worksheets. Each worksheet contains common column headings. Each worksheet has AutoFilters set. I want to be able to change the filter criteria in one worksheet and the other worksheets filters change to reflect the change. e.g. Worksheet a is filtered on Town "Bobsville" so all the other worksheets will automatically change their filter criteria to filter on "Bobsville". Is this possible? I have a limitedknowledge of VBA if it could be done using that.