writing a macro in excel 2003

  jwd 10:32 22 Jan 09

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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Prehistoric Britain is laid out in these Royal Mail stamp illustrations

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…