Excel 2007 : Excel 2007 Duplicated Rows and moving it to new spreadsheet

Hi All,

I've got 13,000 row of data with 45 column. I know there are some duplicated rows and what I would like to do is if there is duplicated row (will be selected for one column (let say, one of the column is Student ID) and I will pick according to this column and I want to move all duplicated Student ID to another file. I'm using excel 2007. I would really appreciated if you can help me on this. Thanks...