Excel 03 - Macros

[jlemond]

I am new to using Macros for Excel. Work still uses Excel 2003. I have a spreadsheet that has the same outline for every day - each person's name, work category, time spent on each project, and so forth.

I need to set up a macro that will add a new sheet to the workbook and name the tab with the current day's date. For example, today's page is titled 03-02-2011. I want a macro that will add a worksheet tomorrow with the same columns/rows and headings, and will title itself 03-03-2011.

Does anyone have any suggestions?

Thanks!

 

[VoG]

Try creating a sheet called Template with all your desired headings etc. then run

Sub AddSheet()
Sheets("Template").Copy after:=Worksheets(Worksheets.Count)
ActiveSheet.Name = Format(Date, "mm-dd-yyyy")
End Sub