1

I'm trying to copy cells B to F to another sheet if the text in cell J contains specific text. As an example case, I'm using the query function as:

=query('Sheet 1'!B1:J,"Select * Where J contains 'Apples'")

and that works fine, but I don't want all cells B to J to be copied across, just cells B to F.

Improve this question
1
  • Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it and even upvote it so others can benefit as well.
    – marikamitsos
    Mar 5, 2021 at 18:12

1 Answer 1

Reset to default
0

You mention:

...but I don't want all cells B to J to be copied across, just cells B to F.

=query('Sheet 1'!B1:J,"Select B, C, D, E, F Where J contains 'Apples'")
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.