Hi Team,
I am going to find entire data in one excel to another two excel and once data found any one excel or both excel will update the status in first excel
Ex:
Input:
Excel A Excel B Excel C
Name Name Name
XXX YYY DDD
YYY AAA YYY
ZZZ XXX ZZZ
Output:
Excel A
Name Status
XXX Found Excel B
YYY Found Excel B and Excel C
ZZZ Found Excel C
Please anyone help me out from this.
I have attached excel for yours Ref
Excel A.xlsx (9.5 KB)
Excel C.xlsx (8.6 KB)
Excel B.xlsx (8.6 KB)
Regards,
Raja G