How to find something in one sheet and add it to another?

Question

I have a problem with Google Sheets. I need to create a list based on the cell contents in the new worksheet. For example: If in the 'Example1' sheet, in cell E2, the value is 'yes', add the entire row to the 'Example2' sheet. Is it possible to do it in Google Sheets?

You can write a Macro for that – Mikku Jun 10 '19 at 09:24 — Mikku, Jun 10 '19 at 09:24

score 0 · Answer 1 · answered Jun 10 '19 at 09:33

0

try it like this:

=QUERY(Example1!A:Z; "where E='yes'"; 0)

answered Jun 10 '19 at 09:33

player0

124,011
12
67
124

How to find something in one sheet and add it to another?

1 Answers1