Hi there -

The column that the macro should "search" by and flag is Account Number.
The "master" workbook would be called Eknow, and there are three worksheets
called 535, 536, 537 respectively. One search and merge workbook is called
CVM 5 and has a tab for 535, 536, 537. There are other search and merge
workbooks called CVM 1 and Eradicates, each with individual tabs for 535,
536, and 537.

Does this make sense? I appreciate your help!

"Joel" wrote:

You need to write a VBA macro. There is too little information provided to
be able to give you any code. Give more details. Column, worksheets names ,
workbooks names.

"Cris" wrote:

Hi! I have two workbooks, not created in the same place and not shared. I'd
like to be able to merge the two documents so that all similar entries are
flagged/highlighted in some way. Please help!