Regarding the “Range does not exist errors” you will need to update what I gave you to work with your ranges, sheet names, etc. That error means that in the context of running that automation for the activity that is giving that error the Range from mine is entered wrong (e.g. wrong column names, sheet name, something like that)
With regards to also adding rows that aren’t present in the 2nd sheet, you’ll to add an extra condition, you’ll need to to this similar to how the “Cells Don’t Match” (activity 188.8.131.52 in my sample) worked
- Right after the Filter Activity (1.4.3), add a “Save for Later” along the lines of “Matching Rows” and set it to 0.
- As the first activity inside the “For Each Excel Row” on Sheet2, add a “Save for Later” and set “Matching Rows” to 1
- After the “For Each Excel Row” over Sheet2 add an “If” set the condition to “Matching Rows equals 0” and then do an Append Range into your output sheet.