Hello there, Have been using this forum and various responses to achieve my goal with limited success so far. I have 2 spreadsheets of information and we are trying to find entries that only exist on the Master and copy them to a new sheet. Sheet 1 contain a number of columns of useful information - Column A is the ID. The same ID may be found in Sheet 2. However if that same ID is not found then we would like the complete Row to be copied to Sheet 3. The end result shows a list of machines that are in the Master Sheet 1 and not found in Sheet 2. Any thought greatly appreciated