delete duplicate

Hi all, I am trying to build a tool in excel that can simulate and give an overview of packing plans, but i am having trouble getting a "timeline" to work. The sheets with the timeline are imported based on choice and will change in how many are imported. It needs to be VBA, the persons who...

Hi, I use excel a lot at work and want to start making my job easier. I am trying to learn how to use VBA, but need an answer on this issue sooner than later. I am trying to get data from a report, but I need to delete duplicate records to get accurate information. However, there are some...

Hello All, I just took my first VBA course and brand new to the forum. I was hoping for some help in deleting duplicate values based off of multiple criterea. Each item has a unique Sec Code. I do not care about the "Group column." My desired results will show the security codes with all of...

Anyone who could help me. That macro asks if I want to delete or not. If I choose "not" it leaves current cell red. How can I degree that. If I choose not to delete it should leave that cell as it was in the begin. Please help me. Sub oma() Range("A:A").Interior.ColorIndex = xlNone For i =...

From range("A1:D150") if any word (It could be names like Pedie, Peter, Agie....excel etc etc) get repeated then I want it to be removed. As there are so many duplicate name being repeated. In this range there should be just 1 word, no repeatation.... Suppose in cells(1) and in cells(4) I...

I have a worksheet with 9000+ rows and 75 columns with many duplicate entries, containing many incomplete cells. Example: Joe Smith 111-11-1111 FL ________ Joe Smith 111-11-1111 __ Purchase Joe Smith ___________ FL Refinance I would like to consolidate this duplicated entry to one (1)...