Hi,
I have multiple worksheets with information on valves on a chemical plant.
Each worksheet is formatted in the same way. Each worksheet ideally should
have identical info for all the valves but this is not the case so I want to
create a master worksheet that consolidates the information from all the
worksheets. I need to first check which worksheets the valve appears on (as
not all valves appear on every worksheet) and then compare the information
from these worksheets - if the information is identical then fill this
information in the corresponding entry on the master worksheet, and if the
information is different then put something like "discrepancy" in the cell
master worksheet. A further complication is that even though a valve may
appear on a certain worksheet, the info in a particular column could be blank
and if so, this should be ignored in the comparison of data.

Any help would be much appreciated as some of the worksheets have 1000+ rows
and to compare the data manually would take weeks!

Regards,
Chief1409