I am trying to delete entire rows if cell data in columns G & K on sheet1 BOTH match the data in column G & K on sheet2. I think whats confusing me is a loop inside a loop (my logic - looping thru the rows of sheet1 with the rows of sheet 2?).
Thank you in advance for any thought - im hoping the solution is that its easier than my train of thought.
The solution should be relatively easy. 1) use a row index to loop UP through the rows from the bottom to the top. If you start at the top, you can leap-frog records and 2) use Application.WorksheetFunction.CountIfs() to determine if the current entries are present in the second sheet. If the result is greater than zero, there is at least one matching entry.
Post a sample workbook with some typical data if you want a tested solution.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Sure thing, and i see the logic behind your explanation - don't think i ever tried that.
Attached is a mock WB. The highlighted cell would represent the matching data, therefore need to be removed.
Thank you again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks