Hello all, I'm new here and I hope somebody can help me out. I'm tryin
to figure out how to compare and delete data using a macro in excel.
have a workbook with 2 sheets. One sheet contains disconnected rat
info for accounts. The other sheet contains install info for accounts


Here is the problem. This is a commission report. We have an issue wit
our billing system that in order to add services to an account that ha
a campaign associated with it, our agents have to take services off o
the account to "break" the campaign. They complete the work order the
start a new one putting the existing services back on and then addin
the new services. Unfortunately, the query pulls all of that data an
it looks like the agent sold more services then they actually did. Th
result would be the agent getting paid more than they should.

What i'm trying to do is create a macro that will compare th
disconnect and install sheets. If a row in the install sheet matche
the row in the disconnect sheet, delete the row and move onto the nex
row. If I can't delete the row, perhaps I can return a value of true i
any rows in one sheet match the other.

Here is an example of my two sheets. Could someone lead me in the righ
direction? Any help would be awesome. Thanks

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=55605
--
Message posted from http://www.ExcelForum.com