Need Excel macro for duplicate records 1

[mav617]

Hi,

I am new to macros in Excel, wondered if I could create one to remove duplicate records? I have two worksheets from different sources with some info repeated. Is there a way I can get the application to remove any duplicated records (other than doing it by 'sort by' and then manually picking them out?)

 

[MakeItSo]

Use Auto-Filter:
select your data range, set data-filter-auto filter - advanced
select "no duplicates" and specify your output range.

Or use some code:

Sub SetFilter()
   Application.ScreenUpdating = False
   Range("A1").CurrentRegion.AdvancedFilter _
      Action:=xlFilterCopy, CopyToRange:= _
      Range("B1"), Unique:=True
   Columns(1).EntireColumn.Delete
   Application.ScreenUpdating = True
End Sub

Beware: Since this is about data deletion, don't forget to backup your file
;-)
And<

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://www.andygalambos.de

 

[xlbo]

Alternatively, you could just search the archives for "duplicate" where you'll find many, many threads that could help you out rather than just posting a question straight away

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[dcompto]

Also, see

http://support.microsoft.com/default.aspx?scid=kb;en-us;240077&Product=xlw2K