Long time lurker but first time poster since haven't found my answer (or at least nothing I can get to work). I'll try to explain what I'm trying to do here.
I'm pulling in data from 2 different sites that use the same name for a data set and each is going into separate sheets in my file. What I want to do is transfer select columns from one sheet into a new sheet based on the data set name and a criteria from the first sheet. Here's example since sure that's not real clear.
Data on 'sheet 1' that comes in. One thing to note is the order of the samples can be random when the data comes in so 'Sample 1' may not always come in row 2. I can probably sort that but would prefer to just link everything by the "Sample" name.
Data on 'sheet 2' that comes in. 'Sample 1' on sheet 1 is same data set as 'Sample 1' on sheet 2 so that name is the common thread between the sheets.
In this example what I'd like to do is copy the column of data on sheet 2 based on sheet 1 criteria being met. I can't figure out how to link a name between different sheets and have the formula automatically copy just those columns from sheet 2 over. For example this would be a sample of sheet 3 output I want if I wanted only data for samples greater than 55 on sheet 1
Is there some array or other function I can use that would automatically populate sheet 3 when sheets 1 & 2 data are updated based on a common naming convention? I've been manually copying columns over but that's getting crazy since getting more data points. Thanks a ton for any help.
I'm pulling in data from 2 different sites that use the same name for a data set and each is going into separate sheets in my file. What I want to do is transfer select columns from one sheet into a new sheet based on the data set name and a criteria from the first sheet. Here's example since sure that's not real clear.
Data on 'sheet 1' that comes in. One thing to note is the order of the samples can be random when the data comes in so 'Sample 1' may not always come in row 2. I can probably sort that but would prefer to just link everything by the "Sample" name.
Data on 'sheet 2' that comes in. 'Sample 1' on sheet 1 is same data set as 'Sample 1' on sheet 2 so that name is the common thread between the sheets.
In this example what I'd like to do is copy the column of data on sheet 2 based on sheet 1 criteria being met. I can't figure out how to link a name between different sheets and have the formula automatically copy just those columns from sheet 2 over. For example this would be a sample of sheet 3 output I want if I wanted only data for samples greater than 55 on sheet 1
Is there some array or other function I can use that would automatically populate sheet 3 when sheets 1 & 2 data are updated based on a common naming convention? I've been manually copying columns over but that's getting crazy since getting more data points. Thanks a ton for any help.