Formula to copy data from one sheet to another sheet based on specific criteria

[gymwrecker]

I need the rows from sheet 1 copied over to a second sheet only for those cells in Column I (PRMK1) with a value of 92. The goal is to have a separate sheet listing only the rows from sheet 1 that have the "92" value in Column I, so when the table is updated, only the new rows that meet those criteria (92) are copied to a second sheet. A copy of my sheet 1 with sample data is attached.

 

[Sergius]

Hello! One option is to put the table into PQ, filter by column PRMK1 with values 92, and then upload it to the sheet. As a result, when updating, new rows will be added to those already on sheet 2.

 

[Fluff]

You can use the Filter function like

=FILTER(Sheet1!A2:N1000,Sheet1!I2:I1000="92")

 

[gymwrecker]

You can use the Filter function like

=FILTER(Sheet1!A2:N1000,Sheet1!I2:I1000="92")

Thank you Fluff! Exactly what I needed!

 

[Fluff]

You're welcome & thanks for the feedback.