I have an excel file (File1.xlxs) that contains a list of postcodes in column S of Sheet1.
I would like to use VBA to compare all postcodes in that file with the postcodes in two other excel files that are located in a different directory (File2.xlxs & File3.xlxs located in S:\Locations).
The postcodes in both of these files are located in column M and both worksheets are named Sheet1.
If the postcode(s) exists in either File2 or File3, I would like to delete the entire row in File1 Sheet1.
Any help would be appreciated.