I have a workbook with individual worksheets. I need to save each worksheet
into a different file name so that they can be distributed to different
people. Each file represents the results for one indivual. I have to send
the worksheets to the propoer manager. Is there a way to
automatically/easily save these as seperate excel files?

thanks
--
Tere for Stan