I have 2 worksheets: "Main" & "Other". Both have 2 columns.
"Main" & "Other" have identical Column A - Invoice number 10 positions
(positions 5, 6 and 7 will be used for the match).
"Main" has column B - date (format DD-MMM-YY)
"Other" has column B - date (format YYYYMMDD)
I need to find "Other" records missing from "Main" based on matching Column
A positions (5-6-7) from both sheets and the correspoding date in Column B.
If positions 5-6-7 and the date from "Main" matches the same in "Other", I
don't want such records.
How can this be done? Any help will be greatly appreciated.
Thank you.