A brief overview of the problem at hand:
There are two workbooks 'ACP.xlsm' and 'Reference.xlsm'. The code must compare a value (from 3rd row) in column A of ACP.xlsm workbook to a value (rows from A2 of) in column A of Reference.xlsm work book or column B, C in that order. If a match is found...