i have two excel one excel contains 4 report names and other excel contains 6 report compare both and find any one is missing from 4 report names and send mail report is missing
Can you provide an excel sample of each?
That way a solution can be developed based upon your column names.
copy.xlsx (9.6 KB)
this is my excel here sheet 2 column name is Transaction_Reference have 4 report and sheet1 column Transaction_Reference have 5 report if any report missing from shee2 then send mail report is missing
Take a look here.
Orange = Match
Red = No Match.
Input.xlsx (11.2 KB)
Main.xaml (13.4 KB)
The results are saved in a new tab called “RESULT”.
Hopefully this helps you