Hi guys,

I need a macro to generate a new worksheet with the name one month after the last worksheet... i.e. I have worksheets called, January 2007, February 2007, March 2007, now I want a macro that will automatically create April 2007 and so on. It would be best if the worksheet could be a copy of another worksheet simply with a different name? Possible?