I have two work sheets that contain bill of material information of about
3000 component items required to build a system. There have been updates to
the bill of material therefore, I need to compare the two worksheets and
create a detailed list of changes or updates from the 3/9 bill of material to
the 3/30 bill of material created. All of the columns headers are the same
are the same for both worksheets, however there may be some added or
subtracted rows or just additional information populated into the columns
that were already in place such as Revision level in row 1 column F may have
went from revision "A" to revision "B" or the qty may be different in Column
H. Can someone help me to compose a formula to compare the two sheets. My
columns are from A thru BI and my row numbers are from 1 to 3000. Please
help.