Please: worksheet comparison

Closed
dlminehart
Posts
2
Registration date
Thursday January 15, 2015
Status
Member
Last seen
January 16, 2015
- Jan 16, 2015 at 07:47 AM
Hello,

Please. 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, please, 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 (please think username), while the others are descriptions, flag settings, etc.

Please. 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, please, 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 please group the results accordingly: changes, additions, deletions.

Anyone please know of such an animal? Thank you exceedingly.