Excel VBA/Macro programming help?!?

Excel Macro (VBA) programming help? Basically, I'm looking for a macro code that would help me create a new sheet AND call it ''week1''. Then, next time you click on the macro it would create another new sheet and call it ''week2'', then ''week3'' and so on.. (I... show more Excel Macro (VBA) programming help?
Basically, I'm looking for a macro code that would help me create a new sheet AND call it ''week1''. Then, next time you click on the macro it would create another new sheet and call it ''week2'', then ''week3'' and so on.. (I also want the new sheets to have some data in them already, as soon as they are opened, so could you leave some room in the vba for that? if not then it doesn't matter)

So yeah, any help would be appreciated. Thanks.
Update: I thought i'd ask it in another category just in case, jeez :|
2 answers 2