I have a workbook for each year with 12 tabs; one for each month. I want to
send out to our staff a monthly chart showing calls worked that month but am
unable to save each month individually; thus they get the whole year
everytime plus what I am working on so far for the current month.

The easiets way is probably to right click the sheet tab you want to send and
select Move or Copy, then in the first dropdown select New Book then check
the copy box. This will place a copy of the sheet in a new workbook which you
can send/save.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Sharon Williams" wrote:

I have a workbook for each year with 12 tabs; one for each month. I want to
send out to our staff a monthly chart showing calls worked that month but am
unable to save each month individually; thus they get the whole year
everytime plus what I am working on so far for the current month.

Hi Sharon

In one step you can use

http://www.rondebruin.nl/mail/folder1/mail5.htm

Or if you use Outlook
http://www.rondebruin.nl/mail/folder2/mail5.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Sharon Williams" <Sharon wrote in message
...
I have a workbook for each year with 12 tabs; one for each month. I want to
send out to our staff a monthly chart showing calls worked that month but am
unable to save each month individually; thus they get the whole year
everytime plus what I am working on so far for the current month.