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.