Hello!
I have two data sets of cash details. I manually reconcile the two data sets each period and I am would like to write my first iterative macro. Below is a snip of the two data sets (also see attached). There can be relationships of 1 to 1, 1 to 2, 1 to 3, or 1 to 4. It cannot be joined and reconciled on the date field because of the timing differences. Could you please help with this exercise? See the date columns and highlighted fields to see the illustration of the matches. At the end of the day, I just want to see the matches (and any unreconciled items) and a column with the differences. THANK YOU!
