Hello and thank you for your reply.

If you know how to write the code for this type of thing, that would be
extremely useful. I have extremely limited knowledge of VBA so wouldn't be
able to write it myself.

Yes, I am aware that the workbook is the whole thing and inside it are the
individual sheets.

I want to create one workbook, containing different sheets for the different
areas so each Area Manager can look at their own details easily and, if
necessary, can easily view the others' too.

Thank you.
Louise

"Otto Moehrbach" wrote:

Louise
Since you need to do this repeatedly (monthly), I would recommend that
you consider doing it via VBA programming. The result would be a one-click
type of thing. That is, one click of the mouse button and all the different
workbooks/worksheets would be created for you. Post back if you think this
might be what you need. Also, clarify what you mean by "worksheet" and
"workbook". Workbook is the Excel file in its entirety. A worksheet is one
sheet in the workbook. Exactly what is it that you want to send to each of
the managers? A workbook containing only the sheets pertinent to that
manager? Or a workbook showing everything but having each manager's area on
separate worksheets? HTH Otto
"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