MickG
Valued Forum Contributor

Hey Mike, need your urgent help
I have many entries for contact details of people which includes first name, last name, phone, address, email, location, pin, etc.
Many entries are repeated. I have found out duplicate entries via email ID. But the problem is some entires have phone, address filled and some do not have out of the duplicate entries. So i want to remove duplicate entries but make sure the data in the filled cells gets copied to the empty cells while removing duplicate. Is it possible?

Thank you Mick for spending time to help me out. It meant a lot to me.
Cheers
Rain

hay, i look for my problem everywhere, and i find just this: http://www.excelforum.com/excel-prog...ell-value.html

in your post, you find solution of my problem!
I want from list to choose what picture to add in my sheet, but if i insert code when onpen the sheet to clear content of list than no picture to show, and but i need 10 list and 10 picture!

My english is very bad but i hope that you understand what i want! Please help!

MickG,

When I tried it in a blank woorkbook it worked fine. When I added it to the project I am working on It does not work and the debugger kicks in.

I will try to post the workbook to the forum so you can see it.

Thanks in advance!
Randy

Hi Mickg

You helped me solving my problem last time . Now i have the same problem but fields order is different and i tried a lot to resolve it but couldn't resolve this problem. Can you please have a look at the thread "Problem in combining records having same address". Its in excel programming section. Could you please help me to solve this one.
Thanks and Regards
Raj

Many thanks for your reply.The code works well but the problem is it doesn't display coulmn headings in the result. please have a look at the attachment and let me know what I need to add in my code to display column headings.The title of the thread is " combining records together". sorry if there is any mistake in sending you message as i am a new member in excel forum.