<div>
Thank you for the alternative idea for how to do this. &nbsp;Makes sense. &nbsp;Thank you.<br />
<br />
I actually ended up creating a crude formula that was =b2&amp;c2&amp;d2&amp;k2 in each sheet, then a 2nd formula (vlookup with the word &quot;Duplicate&quot;) on my main page that compared the two based on that cell and then I ran a delete rows macro based off the results.<br />
<br />
Was hoping there was an easy way to compare the two and delete duplicates and this way is pretty crude, but at the end of the day, it did the job I guess.<br />
<br />
Thanks for your help.
</div>


Thank you for the alternative idea for how to do this.  Makes sense.  Thank you.

I actually ended up creating a crude formula that was =b2&c2&d2&k2 in each sheet, then a 2nd formula (vlookup with the word "Duplicate") on my main page that compared the two based on that cell and then I ran a delete rows macro based off the results.

Was hoping there was an easy way to compare the two and delete duplicates and this way is pretty crude, but at the end of the day, it did the job I guess.

Thanks for your help.

<div>
Do you need additional help at this stage, or are you fine with current state of things?<br />
<br />
Thomas
</div>


Do you need additional help at this stage, or are you fine with current state of things?

Thomas

<div>
My apologies. &nbsp;I thought I had accepted your solution already.
</div>


My apologies.  I thought I had accepted your solution already.

<div>
No problem, have fun coding<br />
<br />
Thomas
</div>


<div>
<div class="content wysiwyg-content">
I know how to create a macro to delete dups on the same sheet, but I need one to remove from different sheets.<br />
<br />
I have two identical sheets, but I need them to stay seperate. &nbsp;I would like to to compare Sheet One to Sheet Two using columns B, C, D K. &nbsp;If there are duplicates, I would like them removed from Sheet One Only.<br />
<br />
I would like this done using VBA.
</div>
</div>


I know how to create a macro to delete dups on the same sheet, but I need one to remove from different sheets.

I have two identical sheets, but I need them to stay seperate.  I would like to to compare Sheet One to Sheet Two using columns B, C, D K.  If there are duplicates, I would like them removed from Sheet One Only.

I would like this done using VBA.

Compare and Remove Duplicates between Two Excel Sheets

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.