Help with code for data entry

[kantian1]

Hi Simon,

I copied the names out of sheet1, and pasted them into column C on the 2007-2008 worksheet and sorted them a-z.

Still no joy, I'm getting a different error now?

What am I doing wrong?

Thanks.

Sorry I get what you mean now, but I am still getting an error? 'Run Time error 91' 'Object Variable or with block variable not set'