VBA to Compare and Sort Data From Two Worksheets

[bpfish36]

Hello, and thank you in advance for your help. My wife and I have been keeping two different Quicken files and we've developed some discrepancies. I'd like to export the data from her Quicken file to one Excel worksheet (Sheet A) and the data from mine to another (Sheet B). I then want to run a macro that will go through the data entry by entry (line by line) and parse the data in to four separate new worksheets. First, if the data matches an entry by date, merchant and amount on both sheets it should be copied into a new sheet for matched data (Sheet C). If it find an entry in Sheet A but not B, that should be copied to Sheet D. If it find data in B but not A that should be copied to Sheet E. Finally if it find data in both sheets that matches 2 of the 3 criteria, i.e. date and merchant but not amount, or merchant and amount with different days, that should go into a final Sheet F. If there's any way to note in Sheets A&B - by shading for example - that they have been checked that would be especially great! Unless I'm wrong, Sheet F will be populated with data that will already be in either D or E , but not all data in D&E will be in F. Thank you again for all the help!

 

[NigelBarrett]

Rather than VBA the simple way would be to load the two files into Power Query and then merge them into the various tables.