Hi Louise

If you have sheet set up for each Area Manager, with the relevant
criteria set up in the criteria area for Advanced Filter to extract the
data that is relevant to him, then having update your Master sheet of
all data, surely it is only a question of refresh for each sheet, then
Mail or Print just that sheet for them.
(I presume you are not sending the whole workbook, as you say you don't
want them to see other area's data.)

Alternatively, depending upon the layout of data in your Master sheet,
you might be able to use a Pivot Table, with Area as a Page Field.
From the resulting Pivot Table report, there is an Option to Show Pages,
which would split out to separate sheets, just the data for that area.
This could then be Printed / Mailed to them.

If this is of interest, post detail of how your data is structured, and
we may be able to help you construct a Pivot Table.


--
Regards

Roger Govier


"Louise" wrote in message
...
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