writing a macro in excel 2003

  jwd 10:32 22 Jan 2009

i wish to write a macro in excel 2003 to copy a worksheet delete some data on it and then save the new worksheet with a different name i.e. jan 09 to be copied and become feb 09, i can do the first bit of copy and delete but when i come to create another worksheet for another months data it will only copy the original worksheet i.e. to create mar 09 from feb 09 the macro only looks at jan 09-- i need to be able to do this for a whole year and so generate 11 new sheets from the original
sounds simple to me but i can't get the blinking thing to work correctly any ideas much appreciated

john davies

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

HP’s new Surface Pro rival is designed specifically for Adobe-using designers and artists

Best kids apps for iPhone & iPad

Que faire si son iPhone ou iPad est tombé dans de l'eau ?