You can record a macro and then make simply changes as required.

here is the code for adding the sheets


For MyYear = 2003 To 2008
Set newsht = Sheets.Add(after:=Sheets(Sheets.Count))
newsht.Name = MyYear
'add recorded code here with modification to use newsht
Next MyYear


for MyYear = 2003 to 2008
sheets.add after:=sheets(sheets.count)
activesheet.name = MyYear
next MyYear

"joemeshuggah" wrote:

Not sure that this is possible by simply recording a macro. Is there a way
to code this by visual basic?

I have a spreadsheet that has a request date column...I am looking to create
a macro that creates a tab for each year, and then takes the information in
the spreadsheet and breaks it out by tab (e.g taking a workbook with one tab
for years 2003-2008, and making a workbook with six tabs showing information
by year)