Comparing and Deleting rows

[snypa]

I have two spreadsheets.

One is like this:

_Computer_|_Date_


The other is like this:

Computer | Last Used[

The problem is that the two lists are different, but some computer
exist in both. The first list is a complete list, the second one is
subset of the first.

How do I extract rows that are common into a separate spreadsheet

 

[Guest]

what do you mean by extract. from which file. do what
after extraction. why 2 files instead of 1 file-2 sheets.