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.