Worksheet comparison

Closed
dlminehart
Posts
2
Registration date
Thursday January 15, 2015
Status
Member
Last seen
January 16, 2015
- Jan 15, 2015 at 03:35 PM
I have two worksheets, each with the same 10 or so columns. In the newer one, a few rows have been added, a few deleted. In the many (1000 or so, hence the need for automation) remaining rows, a few dozen have had changes to one or more of the columns. The first column is essentially the key for the worksheets (think username), while the others are descriptions, flag settings, etc.

The comparison methods I've seen so far would apparently hit the first deleted or added line, and then not resynchronize thereafter. What I need is a comparison that lists all the lines for which there is a change after the initial username column, or where a username row is newly added or deleted. Ideally, it would group the results accordingly: changes, additions, deletions.

Anyone know of such an animal?