You can add a column to Sheet2 that will determine if the row should be
copied or not. For example, if your data in Sheet2 starts in row 3, then
pick a column to the right of the data in Sheet 2, and put this in that
column of row 3:
=IF(ISNA(VLOOKUP(D3,Sheet1!A$2:A$35,1,FALSE)),"No","Yes")
If you start on a different row in Sheet2 than row 3, change the D3 to
reference the first cell in column D you want to look up in Sheet1. Change
the numbers for A$2 and A$35 to use the correct rows in Sheet1. You want the
$ to remain in the formula. Once this is correct, then drag this down for
all the rows in Sheet 2.
From here, depending on how you want the copy/paste done, you can Data |
Filter | Filter All on the data in Sheet2, filter on 'Yes' and manually copy
/ paste into Sheet 3. Alternatively, you can put formulas in Sheet3 to
reference Sheet 2 only if the corresponding column in Sheet2 has a 'Yes' in
it.
If you don't want to see the column in Sheet2, you can build the formulas in
sheet 3 to do the lookup, but if there is a lot of data, it can be slow.
