Creating a simple macro in Excel 2010 - Part 1

[ForevaNewsh]

@learnexcelfunctions ..basically, I need a macro that, whenever you click on it, it creates a new sheet BUT it also names that sheet ''week1''. and then next time you click on the macro, it creates a sheet called ''week2'', then ''week3" and so on... Any chance you could help me please :(

[HomelessOnline]

How do I save a macro so that it's available to every file I ever create or open with Excel 2010?

[redd1th]

@HomelessOnline I believe you would save it to your personalworkbook when asked where you want to save it.

[naved1984]

lOVED IT.. THX...

[south2lt]

The narration is really good.