writing a macro in excel 2003

  jwd 10:32 22 Jan 09
Locked

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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac