I want Excel to find the last entry in column A of a workbook named Source and place its value in a cell in a different workbook called Report. Both of the workbooks are stored on my personal OneDrive. Here is a screenshot of the Report workbook. Thanks for any help you can provide.