Seperate out rows to make a new page in a workbook

[relo]

In my workbook I have records for the years 2006, 2007, 2008. Since it is
sorted by client last name the dates are not sequential. I want to seperate
out all the 2006 records and put them on a seperate sheet called 2006. Then I
want to close the gaps so I don't have spaces in my speadsheet and the row
numbers are in sequence.

 

[Ron de Bruin]

Try Easyfilter

There is a option to do this in the add-n
http://www.rondebruin.nl/easyfilter.htm