I need to compare two spreadsheets and output the differences.

[nikfruetel]

I work in an engineering department and have written a Macro that takes in a bunch of data from from a database that stores all of the engineering drawings and other documents, and outputs an organized drawing list that can be used by the manufacturing department. Next, I need to find a way to quickly compare one version of my output drawing list, to a new version. New versions are created often to ensure my drawing list shows the most recent information. Differences between newer and older versions can include adding new drawings(each drawing gets a row in my list that shows details about it), removing drawings, and changes is drawing names(a drawing called "D-2014-0803_A" would be revision A, and if anything changes in the drawing it becomes revision B (D-2014-0803_B)). Because these possible changes have different effects on the number of rows in the drawing list, I don't know how to set up this comparison, as a cell by cell comparison only works until the first change is detected, then all the row numbers would be thrown off. Does anyone know how I could make this comparison work?

[mongoose36]

You need to iterate backwards

e.g.

Please Login or Register  to view this content.