Hi guys,
I have a set of text in rows which includes duplicates like this:
Column A
Text 1
Text2
Text1
Text500
Text500
I then need to remove the duplicates and put them in column B. I normally use the remove duplicates button in Excel to do this but seeing as I have to do this task every day, I was hoping there would be either a formula or VBA solution which automatically does this? Can someone help me please?
Thanks
just use record macro in the dev tab when you do it and set a shortcut
Sub Reputation() Dim Problem as Variant Dim Reputation as Integer For Each Problem in Forum.Threads If Problem.Title = "*[Solved]*" and Solver.Name = "Leon V (AW)" Then Reputation = Reputation + 1 Next Problem End Sub
thanks for the advice. I could do this but I'd still have to run the macro every time. I want it so that as soon as I paste in the data, the data is populated in a different column without duplicates. is this possible?
you could attach it to the worksheet_change() event.
or you could record the paste as part of the macro and set the sortcut as Ctrl+V
Thanks Leon, I think this is what I'll have to do.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks