Deleting Repeated Data

I am in need of some way to delete repeating values when they are entered into excel.

Example.

Column A
Row1 12
Row2 13
Row3 12

I need row 3 to be automaticaly deleted (the whole row.) what I am doing is importing data from another workbook, but that data will contain previouse information that has already been imported and I need to delete that previouse information after I past in the data. Is there a way that Excel will search for the recuranse and delete the row where it happens.

Thank you.

Try:

Please Login or Register  to view this content.

Got this from C Pearson (http://www.cpearson.com/excel/duplicat.htm)website and adapted it to suit yours. Might not be what your looking for though!

HTH,
mccreaso

Just came across this:

Please Login or Register  to view this content.

@ http://www.cpearson.com/excel/deleting.htm , exactly what your looking for?

mccreaso

MCCREASO!! That is exactly what I needed thank you!