Selecting and Copying separate rows of data

Hey guys,

So I have two tabs up, in the second tab there is a column with mostly numerical values, a few #N/A because I used a vlookup function. There is also a column in tab 1 with numbers. How do I get it so that the values in tab 2 are selected in tab 1, so I can copy and paste the corresponding rows into a new document.

Hello Tangobrovo33,

You may want to attach an example file for what you are trying to do....

unfortunately I can't. Just imagine an excel file with two tabs. On tab one in column A, is the numbers 1-20 (in my case it goes into the 10's of thousands but lets just work on a small scale). On tab 2, column A, there are 15 numbers throughout A1-A20 (the cells with no values are blank). How do I get it so that I can somehow filter the values in tab 2, through tab one, so only the 15 numbers in tab 2 are showing in tab 1.

Does that make it any clearer?

I would lean towards a vba solution if I truly want everything filtered, selected, and copied in one step. But a two (or three) step approach would be to add a column to table 1. That column would have the equation:
=MATCH(A1,Sheet3!$A$1:$A$15,0)

A1 would change for each row, the Sheet3!$A$1:$A$15 would be your table 2 to match.

This would generate a list of numbers and #N/As. Sort your table using the match column, and the #N/As should move to the top or bottom. Now just select the rows that don't have the #N/As and copy.

Pauley

The problem is the positions are different. So if each row is corresponding to a person, whoever is in row 5 on tab 1, is different from who is in row 5 on tab 2. This might be an easier way to look at it, but is there any way to use the actual filter function, and just filter for all the numbers in column A on tab 2. I have tried using the custom filter and advanced but none seem to work.