Monday, March 07, 2005

Compare Cells Answer

Shantanu Oak has commented on my post regarding comparing two cells.

It seems that "Erlandsen Data Consulting" has VBA Code to compare two ranges or two worksheets.

I myself, use Spreadsheet assistant for that purpose.
Spreadsheet assistant can be downloaded from...

If you have the "Spreadsheet Assistant" installed, follow these steps.
1. Select the range you want to compare. Choose ""All the Assistants"" from Quick Menu.
2. Under Special Assistants choose ""Compare Two Columns - Stop When Not Alike...""
3. Click on Ok to accept the first range. Select the other cell range in the next dialog box. You can color the cells green if the contents are different.

Thanks Shantanu