deleting duplicated data using macros

[deano3141]

Hi there I am importing client information from the internet into a sheet.

What I need to be able to do is click a button to run a macro that finds and deletes any duplicated data.

Mr A Blogs Mr I Blogs
Mr B Blogs Mr H Blogs
Mr C Blogs Mr S Blogs
Mr D Blogs Mr J Blogs
Mr E Blogs Mr M Blogs
Mr F Blogs Mr W Blogs
Mr G Blogs Mr L Blogs
Mr H Blogs Mr C Blogs

I need to be able to click the button, it finds the duplicated data and then deletes the second of each duplication it finds.

I hope someone can help.


Kind Regards
Deano

[scottlutes]

Take a look at this thread. The macro from Trebor76 is a good code. A little modification, changing the message box, or even executing after it displays, may get you what you need.

http://www.ozgrid.com/forum/showthread.php?t=169011