Seperate out rows to make a new page in a workbook
 

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.

Seperate out rows to make a new page in a workbook
 

Try Easyfilter

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"relo" wrote in message ...
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.