<div>
Hi,<br />
You have to loop through Sheet 1. For every row, you find out the relevant row in Sheet 2 and list out the difference of two rows after the comparison.
</div>


Hi,
You have to loop through Sheet 1. For every row, you find out the relevant row in Sheet 2 and list out the difference of two rows after the comparison.

<div>
Is there a vba script to perform this ?
</div>


<div>
Read<br />
<a href="http://www.excel-easy.com/vba.html" rel="ugc">http://www.excel-easy.com/vba.html</a>
</div>


Read
http://www.excel-easy.com/vba.html [http://www.excel-easy.com/vba.html]

<div>
Thanks for the link...but is there a formula or vba solution to do this? the list on the link is exhaustive.
</div>


Thanks for the link...but is there a formula or vba solution to do this? the list on the link is exhaustive.

<div>
You need to loop through 1st list first, to do the comparison on 2 lists.
</div>


You need to loop through 1st list first, to do the comparison on 2 lists.

Comparator.xlsm

<div>
<div class="content wysiwyg-content">
Want to compare two sheets and highlight the difference... Every week the data from sheet 2 changes and may have a different sort order.. I want to highlight any difference between the two sheets... <br />
<br />
<br />
<br />
<br />
Data is similar to the link below:<br />
<br />
<a href="http://filedb.experts-exchange.com/incoming/2012/03_w13/564010/Compare-example.JPG" rel="ugc">http://filedb.experts-exchange.com/incoming/2012/03_w13/564010/Compare-example.JPG</a>
</div>
</div>


Want to compare two sheets and highlight the difference... Every week the data from sheet 2 changes and may have a different sort order.. I want to highlight any difference between the two sheets... 




Data is similar to the link below:

http://filedb.experts-exchange.com/incoming/2012/03_w13/564010/Compare-example.JPG

Compare Excel Sheets

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

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.

Visual Basic Classic

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.