I have two Excel workbooks that must be compared row-by-row. The rule is simple: for example pick the value in Column E along with Amount from column G of the first file and match it against value in Column F and corresponding amount in column T of the second file. If it matches then need to copy few values from First file and some from second file and past it in a new workbook. for the unmatched reocord we run the same logice but with another column value with amounts, what evermatches in this second run, it should be copied to the new workbook created above. Some columns in the new workbooks has conditions to be met like lenght etc, so before updating new work book those columns values needs to be set as per condition and then to be updated. I’m open to how you achieve this: a VBA macro, Power Query, or even a well-structured Python script are all fine as long as the final output meets these acceptance criteria: • The three original workbooks remain intact • A newworkbook created will have all matched records, with the agreed columns pulled from different source file • No manual intervention is needed beyond pointing the process at the three files and running it There are few columns with conditions that will explain once we connect. If something is unclear—such as which extra columns I want copied over—feel free to flag it at the start so we lock that down before you code.