I have 2 spreadsheets. Sheet "X" contains approx 250 rows
with the rows in column A containing a unique reference,
other 8 columns various data. Spreadsheet "Y "contains
say 2000 rows with the rows, column A containing a unique
reference. Etc.
In spreadsheet "Y" among column A references are the same
unique references contained in my spreadsheet "X". I am
looking for a method to compare the two sheets and to
eliminate the records in sheet "Y" that do not correspond
to the references in spreadsheet "X" column A.

Many thanks,
Geo