If function to pull data from sheet1 to sheet2

[FGaxha]

Hi,
Help needed:
Sheet1: A,B,C,D
Sheet2:A2 =if(sheet1!A2=“yes”,B,C,D

I need all data from sheet 1 to sheet2 with no blank rows in between.
Sheet1:columnA”yes” can be randomly at ror 2,13,22,55 ,,,,,,,,

Thank you

 

[myall_blues]

Sheet1:

Book2
	A	B	C	D
1
2	Yes	2B	2C	2D
3
4
5	Yes	5B	5C	5D
6	Yes	6B	6C	6D
7
8	Yes	8B	8C	8D
9
10
11
12
13	Yes	13B	13C	13D
14
Sheet1

Sheet2:

Book2
	A	B	C	D	E
1	Yes	2B	2C	2D
2	Yes	5B	5C	5D
3	Yes	6B	6C	6D
4	Yes	8B	8C	8D
5	Yes	13B	13C	13D
6
Sheet2

Cell Formulas
Range	Formula
A1:D5	A1	=FILTER(Sheet1!A:D,Sheet1!A:A="Yes")
Dynamic array formulas.

 

[FGaxha]

Thank you so much, but it was a mistake in my query,
Sheet1: A,B,C,D
Sheet2:A2 =if(sheet1!A2=“yes”,C,D

Thanks again

 

[myall_blues]

To confirm, which columns do you want on sheet 2, and what columns do you want them to appear in?
E.g. I want only column C and D results to appear on sheet 2, and I want those results to appear in columns A and B.

 

[myall_blues]

Put this formula in Sheet2 C1

=FILTER(Sheet1!C:D,Sheet1!A:A="Yes")

 

[FGaxha]

Thank you,
This is great