How do i Import a rows from one Google Sheet to another with filter?

Question

I have a Google Form, the answers go to Google Sheets.
I want to import answers from sheets (Аnswer) into new sheets but with a filter applied.
For example: from sheets (answer) into a new table, I import answers only from 100 REPPM. For this I use the following formula:
=QUERY(IMPORTRANGE ("https://docs.google.com/spreadsheets/d/1dMo6F1CTxAaEx1bS2NEu4kIu5hJTCBbCt13AV2E_f2w/edit#gid=1390527531","Answer 1!A:E"),"Select Col1,Col2,Col3,Col4,Col5 Where Col2 Matches '"&100 REPPM&"'")

My formula is incorrect, please help.

Answer 1

To copy those rows from one spreadsheet file to another, use this:

=query(importrange("1dMo6F1CTxAaEx1bS2NEu4kIu5hJTCBbCt13AV2E_f2w", "Answer 1!A1:E"), "where Col2 = '100 REPPM' ", 1)

To copy those rows from one tab to another within the same spreadsheet file, you should not use importrange(). Instead, use a regular range reference, like this:

=query('Answer 1'!A1:E, "where B = '100 REPPM' ", 1)

In the event your spreadsheet is in a locale that uses semicolons as formula argument separators, replace commas , in the above formulas with semicolons ;.