Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Compare identifier columns from 2 sheets - remove rows that are dups
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="isabelle, post: 7402371"] hi Livin, Sub test() With Sheets("Sheet2") For i = .Range("A65536").End(xlUp).Row To 1 Step -1 If Not IsError(Application.Match(.Range("A" & i), Sheets("Sheet1").Range("A:A"), 0)) Then .Rows(i).Delete Shift:=xlUp End If Next End With End Sub -- isabelle Le 2012-05-04 19:35, Livin a écrit : [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Compare identifier columns from 2 sheets - remove rows that are dups
Top
