I have workbook which i use to track sales activity on a monthly
basis. The activiy in the current month is listed on the sheet called
"current". I have another sheet (called "Recap") which stores monthly
sales figures in a table and graphs the values against projections. I
would like a macro which would accomplish the following

1. Copy the current sheet and rename it with the name of the month -
the month has been entered into cell J2

2. Change all the cells in the copied sheet to values

3. Enter the values from 3 cells on the copied sheet into the
approprate cells on the "Recap" Sheet.

as a seperate issue is it possible to create a macro which will print a
sheet as a pdf and autosave to specific network drive

Thanks for your help