Compare a parameter for a name across two different sheets and give an output message

[vijitkumar]

At any given point of time, two sheets of data to be compared. Either in same workbook or a different workbook.

Attached is a file where there are 3 sheets of data.

Instance1: For Sam in master sheet, compare the 'coverage %' with Sam in Coverage sheet and give the output as : Values match, Coverage % is 90 for Sam in both sheets

Instance2: For Lisa in master sheet, compare the 'Team size' with Lisa in Team size sheet and give the output as : Values do not match, Team size is 35 in Master sheet and team size is 33 in Team size sheet

Note the data can be in any cell. The only thing that will remain constant will be the names and the parameters across the sheets.

Can someone help me with the right approach to be taken? I understand only vba approach will work.

 

[vletm]

vijitkumar
a) Either in same workbook or a different workbook.
... if cannot find 'non-master-table' in same workbook,
... ... then how to guess ... from where?

b) Note the data can be in any cell.
... is there any practical reason of those?
... is that useful?

 

[vijitkumar]

vijitkumar
a) Either in same workbook or a different workbook.
... if cannot find 'non-master-table' in same workbook,
... ... then how to guess ... from where?

b) Note the data can be in any cell.
... is there any practical reason of those?
... is that useful?

Hi, Thank you for the above response. This is required because a manager gets a data in this fashion. He needs to quickly ensure that the parameter value is same and there is no error in the report. Check the file I attached. It is the closest I could get to arrive at a solution. Is there something that you can suggest to improve it or a different approach that can work.

 

[vletm]

vijitkumar
b) ... missing answers