I have a large worksheet (thousands of rows), containing absence details for
all Areas in our Company. I have to send this worksheet out to each Area
Manager showing their absence details for that month. However, rather than
sending them the whole worksheet with all areas on, I want to create a
workbook containing separate worksheets for each Area to make it easier for
them to read because they are not advanced Excel users.

The method I have used so far is the 'advanced filter'. By entering
criteria, ie. Area 1' etc. onto a new worksheet and performing an advanced
filter, this only shows those people who work in Area 1.

This works perfectly fine, however, I wondered if there were any alternative
ways that may be quicker, as I have to produce this on a monthly basis.

I don't want to use the 'auto filter' as they can then use the filter arrows
to view other Areas' information.

Hope this makes sense? Any help would be appreciated.

Thank you.

Louise