Excell function/formula to copy from once cell to another if a Yes is contained in a certain cell

[JJDelport]

Hi Everyone.

hope you well. i have a question and cant seem to get it right anyway.

I have got cell A 15:16 which if cell a16 Contains Yes then the entered data in cell D13:I14 will copy to cellD15:I16

If someone can help with with a solution I will appreciate it.

Thank you.

 

[etaf]

i have just used a nested IF
you can just apply a range - BUT it will copy 0 where blank

as you have 365 - I suspect there is a better way to do it using arrays - i cant seem to get the copy to be blank if original cell blank - i get 0

so
in D15
=IF($A$16="yes",IF(D13="","",D13),"")
copy across and down

Book6
	A	B	C	D	E	F	G	H	I	J	K
1
2
3
4
5
6
7
8
9
10
11
12
13				1	2	3	4
14						a	b	b
15				1	2	3	4
16	yes					a	b	b
17
18
19
Sheet2

Cell Formulas
Range	Formula
D15:K16	D15	=IF($A$16="yes",IF(D13="","",D13),"")