S
Sherry
Using: Windows XP/Excel 2003 - What I'm trying to do is compare two
inspection forms (that should be exactly the same) to see if anyone has
changed any of the questions on the forms. For example: In the "master form"
a specific cell asks the question for the "sq. ft. of a building" and in the
"copy form" I want to compare, if someone has changed that question to ask
the "qty of units in the building". I want to compare that each cell has
exactly the same data in both of the the forms and if different then to
highlight the cells with differences in red on the "copy form". What I have
to accomplish is that I have 200+ forms that I have to compare to a single
master form to find which cells are different so that I can have them mapped
to our database. I do understand that i wil have to do them one by one, I
just know there is an easier way than manually comparing each individual cell
in 200+ forms, Yikes! I am somewhat new to this so please explain steps in
detail. I appreciate any help that you can give.
inspection forms (that should be exactly the same) to see if anyone has
changed any of the questions on the forms. For example: In the "master form"
a specific cell asks the question for the "sq. ft. of a building" and in the
"copy form" I want to compare, if someone has changed that question to ask
the "qty of units in the building". I want to compare that each cell has
exactly the same data in both of the the forms and if different then to
highlight the cells with differences in red on the "copy form". What I have
to accomplish is that I have 200+ forms that I have to compare to a single
master form to find which cells are different so that I can have them mapped
to our database. I do understand that i wil have to do them one by one, I
just know there is an easier way than manually comparing each individual cell
in 200+ forms, Yikes! I am somewhat new to this so please explain steps in
detail. I appreciate any help that you can give.