http://xldynamic.com/source/xld.Deleting.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Tariq" wrote in message ...
|I have a MS Excel sheet with with rows of information about staff, first
| name, surname and staff, staff no.
|
| The spreadsheet is very big how can I identify duplicate enties and delete
| them for the whole speadsheet by using a macro or other method.