Compare cell values of different Workbooks and prompt message
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
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.
Jeric A. Lapuz
Last edited by jericlapuz; 12-21-2012 at 03:23 AM.
Reason: grammar correction
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1