I have a worksheet which consists of records from different years. One of the columns displays the year such as "2004" etc.

What I would like to do is move the data to individual worksheets based on year. So I would end up with all the year 2004 records on one sheet, 2005 on another, etc. Then I would like to name the sheet based on the year.

I need to do this with a macro.

Any help would be greatly appreciated. Thanks.