An Excel file exists with approximately 541 entries in relation to loans made to someone. These have to be cross referenced to statements totalling some 390 pages. These statements are in pdf.
I need the dates of loans made, which could be on a Saturday or Sunday be referenced to the bank statements. Perhaps highlighted on yellow where they have been accounted for (on both the Excel and the pdf) and a column in Excel showing where in the pdf and the pdf just the date highlighted where it has been accounted for. The purpose of the exercise is so a Court can see that funds were loaned one say and proven by the withdrawal noted on the statements. Some will not show up as this will be $ from my pocket. Money accessed from an auto telling machine over the weekend will show on the statement the next business day. One file has to support the other