Copy values from one workbook to another if condition is met

[Lenna]

Hello,

I would like to copy two values (NC and PC) from a .csv files to Master workbook. I’m not sure if I need to open the .csv files to accomplish this?
To find the values in each .csv, “trimmed mean” needs to be located in column A of .csv file. The next row after “trimmed mean” that contains “NC” in col A is the negative control and I need to copy the value of the cell to the right to Mater workbook col A. The next row after “trimmed mean” that contains “PC” in col A is the positive control and I need to copy the value one cell to the right to Master workbook col B. Please suggest what is the best way to accomplish this task?

Thank you

 

[kumarapush123]

Please explain what you mean by 'NC' 'PC' "trimmed mean'? Would be helpful to give solution if a sample input and expected output is mentioned in the query.

 

[Lenna]

Please explain what you mean by 'NC' 'PC' "trimmed mean'? Would be helpful to give solution if a sample input and expected output is mentioned in the query.

Sorry, I'm refering to text in a cell in column a. Once i find a cell that contains "trimmed mean" in col a. I need to find the next occurrence of text "nc" and "pc" in col a and copy the corresponding values from column b to master workbook.