I'm trying to compare two values in two different workbooks. Once compared i
need it to give me the cell address where it's located in workbook 2. Once i
identify where the value is located, i need to go to that cell address to
populate the cells adjacent to it. Can anyone help me figure out how to do
this, please. Thank you.