Compare cell values of different Workbooks and prompt message using macro

Hi to all!


Hope someone can help me to deal with my problem. I have to workbooks named wbOne and wbTwo with validate command buttons each.
Both workbooks use sheet1 only. My problem is that if I copy data to these sheets and then i click the validate, the macro will then check if there similar values. e.g

wkOne
Sheet1 ColumnA
123456
234567
456789

wkTwo
Sheet1 ColumnA
123456
345678
567890


Notice that the first data for both workbooks is similar. Then after clicking the validate button, a prompt pop-up message will appear

"wkOne and wbTwo has the same data 123456 in A1"

The added condition is that the macro will get the filename of the two workbooks with the same data as well as the exact address of the cell and the similar value.

Thank you so much in advance.

Regards,
Jeric A. Lapuz