Here's the situation that I want to be able to automate via an excel or VBA function: I have workbook A with multiple worksheets; each worksheet lists the revenue checks to oil & gas owners that are written for a given month. In workbook B that is exported and downloaded daily from the bank are the previous day's cleared checks. I would like to mark the checks in workbook A that have cleared. Considerations: I would like to download new cleared check info every day without keeping the last day's so I'm not sure if that would be possible. I'm an intermediate excel user who would guess that I would try to do a lookup formula for this. What would be the easiest way, if possible to accomplish this? I could possibly consolidated multiple worksheets into one in Workbook A. Thanks in advance.