I have a spreadsheet with autofilters separating different offices financial
information. I want to sent select autofilters to office managers, but do
not not want them to have access to other offices information.

How can I do this and still save the formatting, etc?