Need to pull all values from a reference sheet into a new blank sheet

Carlee Schiffner

Hello!

I am needing to pull all values from a reference sheet column into a new blank sheet. I do not want the whole row from the reference sheet, or I would set up a "copy row" automation. Is this possible?

Thanks!

Paul Newcome

Is there a reason you are wanting to pull it into a separate sheet as opposed to creating a row report?

Carlee Schiffner

I'm going to cross reference more data from 2 existing sheets to my new sheet as an audit.

Paul Newcome

Do you have some sort of unique ID that can be used to cross reference the two?

Carlee Schiffner

My sheet was completely blank, but turns out the unique ID was going to be a manual entry to the sheet. I figured out how to cross reference both my reference sheets with an IF statement and INDEX/MATCH. Thanks Paul!

Paul Newcome

If you have the unique ID already on both of the source sheets, you can use a copy row from one to avoid having to manually enter the IDs and just hide the extra columns.