I have an excel work book with 14 sheets. I would like to be able to create a macro that would copy and save
one sheet from the workbook to another network location. Any advice on how to do this. The sheets
are named for the months so I have sheets January - December. At the end of this month I would like to save
and send the January sheet to the location I need and also give it a new name.

Thanks for all help.

This iis probably overkill, but it copies one spreadsheet to another using a third spreadsheet to control the process.

Get it here.

To copy a single worksheet to a new workbook all you need is this.

You can then use something like this to save it, obviously changing paths/names as required.