VBA script to find and Delete rows with Duplicate data

[ira_deorum]

Ok guys really need your help for a script here ( VBA ).

​

I have data in four columns and 1000s of rows.

in Col A i have "NE ID" , Col B i have "SITE ID". SITE ID is composed of up to minimum of 2 NEs and a maximum of 6 NEs.Col C has "start date of an event" and Col D has " End date of an Event". I want a script that combines Data in cell for Col B and Col C e.g. E3=B3&C3. Once the script populates this new column ( Col E ) with data. I then want the script to find duplicate Cells in this Column and then highlight them. Once highlighted it can copy them the rows that contain duplicate data from Col E to a new sheet. Once on the new sheet it can then delete the duplicates to only be left with unique values.

sample sheet:

http://www.flickr.com/photos/78459546@N04/6878264872/

Please assist. ideas are also welcome

br
Ira D