ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I compare 2 worksheets, 1 old, 1 updated to find difference (https://www.excelbanter.com/excel-discussion-misc-queries/10696-how-do-i-compare-2-worksheets-1-old-1-updated-find-difference.html)

alienstew

How do I compare 2 worksheets, 1 old, 1 updated to find difference
 
I have 2 large worksheets of text information, the 2nd being an update of the
first, I need to identify/highlight the updated fields. Is there a way to do
this?

Jim Rech

There is a workbook compare add-in by Myrna Larsen and Bill Manville on Chip
Pearson's site you might try:

http://www.cpearson.com/Zips/Compare.ZIP

--
Jim Rech
Excel MVP
"alienstew" wrote in message
...
|I have 2 large worksheets of text information, the 2nd being an update of
the
| first, I need to identify/highlight the updated fields. Is there a way to
do
| this?




All times are GMT +1. The time now is 12:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com