VBA macro to get data from sheet4 and compute formula from sheet5 for run 2. Ultimately, this will be for multiple runs so if it ac

[Nlhicks]

Sheet 4 (Data Sheet)

Test Tracking_Rev A.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1			RUN ONE								RUN TWO
2		Testing	Estelle	Estelle	Simpleton	Simpleton	Sampson	Sampson	Trex	Trex	Estelle	Estelle	Simpleton	Simpleton	Sampson	Sampson	Trex	Trex
3	Number	Combinations	+	-	+	-	+	-	+	-	+	-	+	-	+	-	+	-
4	Number_01	Trex	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0
5	Number_02	Estelle & Sampson	0	0	0	0	0	1	0	0	1	0	0	0	0	1	0	0
6	Number_03	Simpleton	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0
7	Number_04	Estelle, Simpleton & Trex	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0
8	Number_05	Sampson	0	0	0	0	5	1	0	0	0	0	0	0	6	0	0	0
9	Number_06	Estelle	2	0	0	0	0	0	0	0	2	0	0	0	0	0	0	0
10	Number_07	Estelle & Trex	2	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0
11	Number_08	Estelle	10	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0
12	Number_09	Sampson	0	0	0	0	1	1	0	0	0	0	1	0	0	0	0	0
13	Number_10	Simpleton	0	0	1	0	0	0	0	1	0	0	0	1	0	0	3	0
14	Number_11	Simpleton & Trex	0	0	1	0	0	0	2	0	0	0	0	0	0	0	2	0
15	Number_12	Trex	0	0	0	1	0	0	1	1	0	0	0	0	0	0	0	1
16	Number_13	Sampson & Simpleton	0	0	1	0	1	0	0	0	0	0	2	0	1	1	0	0
17	Number_14	Sampston & Simpleton	0	0	0	0	0	0	0	0	0	0	2	0	1	0	0	0
Sheet4

Sheet5 Formula and Tracking Sheet

Test Tracking_Rev A.xlsm
	B	C	D	E	F	G	H	I
3			Run 1		Run 2		Verified
4			Verified (Y/N)	Tested	Verified (Y/N)	Tested	(Y/N)
5	Number_01	Trex	N	Y
6	Number_02	Estelle & Sampson	N	Y
7	Number_03	Simpleton	N	Not Tested
8	Number_04	Estelle, Simpleton & Trex	Y	Y
9	Number_05	Sampson	N	Y
10	Number_06	Estelle	Y	Y
11	Number_07	Estelle & Trex	N	Y
12	Number_08	Estelle	Y	Y
13	Number_09	Sampson	N	Y
14	Number_10	Simpleton	Y	Y
15	Number_11	Simpleton & Trex	Y	Y
16	Number_12	Trex	N	Y
17	Number_13	Sampson & Simpleton	Y	Y
18	Number_14	Sampson & Simpleton	N	Not Tested
Sheet5

Cell Formulas
Range	Formula
D5	D5	=IF(AND(IF(COUNTIFS(Sheet4!C2:J2,"Trex",Sheet4!C3:J3,"-",Sheet4!C4:J4,">0"),"N","Y")="Y",IF(OR(IF(COUNTIFS(Sheet4!C2:J2,"Estelle",Sheet4!C3:J3,"-",Sheet4!C4:J4,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!D2:K2,"Estelle",Sheet4!C3:J3,"+",Sheet4!C4:J4,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")="Y"),"Y","N")
E5	E5	=IF(OR(IF(COUNTIFS(Sheet4!C2:J2,"Trex",Sheet4!C3:J3,"-",Sheet4!C4:J4,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!D2:K2,"Trex",Sheet4!C3:J3,"+",Sheet4!C4:J4,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")
D6	D6	=IF(AND(IF(COUNTIFS(Sheet4!C2:J2,"Estelle",Sheet4!C3:J3,"-",Sheet4!C5:J5,">0"),"N","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Sampson",Sheet4!C3:J3,"-",Sheet4!C5:J5,">0"),"N","Y")="Y",IF(AND(IF(OR(IF(COUNTIFS(Sheet4!C2:J2,"Estelle",Sheet4!C3:J3,"-",Sheet4!C5:J5,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Estelle",Sheet4!C3:J3,"+",Sheet4!C5:J5,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Sampson",Sheet4!C3:J3,"-",Sheet4!C5:J5,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Sampson",Sheet4!C3:J3,"+",Sheet4!C5:J5,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")="Y"),"Y","Not Tested")="Y"),"Y","N")
E6	E6	=IF(AND(IF(OR(IF(COUNTIFS(Sheet4!C2:J2,"Estelle",Sheet4!C3:J3,"-",Sheet4!C5:J5,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Estelle",Sheet4!C3:J3,"+",Sheet4!C5:J5,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Sampson",Sheet4!C3:J3,"-",Sheet4!C5:J5,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Sampson",Sheet4!C3:J3,"+",Sheet4!C5:J5,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")="Y"),"Y","Not Tested")
D7	D7	=IF(AND(IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"-",Sheet4!C6:J6,">0"),"N","Y")="Y",IF(OR(IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"-",Sheet4!C6:J6,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!D2:K2,"Simpleton",Sheet4!C3:J3,"+",Sheet4!C6:J6,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")="Y"),"Y","N")
E7	E7	=IF(OR(IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"-",Sheet4!C4:J4,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!D2:K2,"Simpleton",Sheet4!C3:J3,"+",Sheet4!C4:J4,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")
D8	D8	=IF(AND(IF(OR((IF(COUNTIFS(Sheet4!C2:J2,"Estelle",Sheet4!C3:J3,"-",Sheet4!C7:J7,">0"),"N","Y"))="Y",(IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"-",Sheet4!C7:J7,">0"),"N","Y"))="Y",(IF(COUNTIFS(Sheet4!C2:J2,"Trex",Sheet4!C3:J3,"-",Sheet4!C7:J7,">0"),"N","Y"))="Y"),"Y","N")="Y",IF(AND(IF(OR(IF(COUNTIFS(Sheet4!C2:J2,"Estelle",Sheet4!C3:J3,"-",Sheet4!C7:J7,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Estelle",Sheet4!C3:J3,"+",Sheet4!C7:J7,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"-",Sheet4!C7:J7,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"+",Sheet4!C7:J7,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Trex",Sheet4!C3:J3,"-",Sheet4!C7:J7,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Trex",Sheet4!C3:J3,"+",Sheet4!C7:J7,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")="Y"),"Y","Not Tested")="Y"),"Y","N")
E8	E8	=IF(AND(IF(OR(IF(COUNTIFS(Sheet4!C2:J2,"Estelle",Sheet4!C3:J3,"-",Sheet4!C7:J7,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Estelle",Sheet4!C3:J3,"+",Sheet4!C7:J7,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"-",Sheet4!C7:J7,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"+",Sheet4!C7:J7,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Trex",Sheet4!C3:J3,"-",Sheet4!C7:J7,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Trex",Sheet4!C3:J3,"+",Sheet4!C7:J7,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")="Y"),"Y","Not Tested")
D9	D9	=IF(AND(IF(COUNTIFS(Sheet4!C2:J2,"Sampson",Sheet4!C3:J3,"-",Sheet4!C9:J9,">0"),"N","Y")="Y",IF(OR(IF(COUNTIFS(Sheet4!C2:J2,"Sampson",Sheet4!C3:J3,"-",Sheet4!C9:J9,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!D2:K2,"Sampson",Sheet4!C3:J3,"+",Sheet4!C9:J9,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")="Y"),"Y","N")
E9	E9	=IF(OR(IF(COUNTIFS(Sheet4!C2:J2,"Sampson",Sheet4!C3:J3,"-",Sheet4!C8:J8,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!D2:K2,"Sampson",Sheet4!C3:J3,"+",Sheet4!C8:J8,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")
D10	D10	=IF(AND(IF(COUNTIFS(Sheet4!C3:J3,"Estelle",Sheet4!C4:J4,"-",Sheet4!C10:J10,">0"),"N","Y")="Y",IF(OR(IF(COUNTIFS(Sheet4!C3:J3,"Estelle",Sheet4!C4:J4,"-",Sheet4!C10:J10,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!D3:K3,"Estelle",Sheet4!C4:J4,"+",Sheet4!C10:J10,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")="Y"),"Y","N")
E10	E10	=IF(OR(IF(COUNTIFS(Sheet4!C3:J3,"Estelle",Sheet4!C4:J4,"-",Sheet4!C9:J9,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!D3:K3,"Estelle",Sheet4!C4:J4,"+",Sheet4!C9:J9,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")
D11	D11	=IF(AND(IF(COUNTIFS(Sheet4!C2:J2,"Estelle",Sheet4!C3:J3,"-",Sheet4!C10:J10,">0"),"N","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Trex",Sheet4!C3:J3,"-",Sheet4!C10:J10,">0"),"N","Y")="Y",IF(AND(IF(OR(IF(COUNTIFS(Sheet4!C2:J2,"Estelle",Sheet4!C3:J3,"-",Sheet4!C10:J10,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Estelle",Sheet4!C3:J3,"+",Sheet4!C10:J10,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Trex",Sheet4!C3:J3,"-",Sheet4!C10:J10,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Trex",Sheet4!C3:J3,"+",Sheet4!C10:J10,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")="Y"),"Y","Not Tested")="Y"),"Y","N")
E11	E11	=IF(AND(IF(OR(IF(COUNTIFS(Sheet4!C2:J2,"Estelle",Sheet4!C3:J3,"-",Sheet4!C10:J10,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Estelle",Sheet4!C3:J3,"+",Sheet4!C10:J10,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Trex",Sheet4!C3:J3,"-",Sheet4!C10:J10,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Trex",Sheet4!C3:J3,"+",Sheet4!C10:J10,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")="Y"),"Y","Not Tested")
D12	D12	=IF(AND(IF(COUNTIFS(Sheet4!C3:J3,"Estelle",Sheet4!C4:J4,"-",Sheet4!C12:J12,">0"),"N","Y")="Y",IF(OR(IF(COUNTIFS(Sheet4!C3:J3,"Estelle",Sheet4!C4:J4,"-",Sheet4!C12:J12,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!D3:K3,"Estelle",Sheet4!C4:J4,"+",Sheet4!C12:J12,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")="Y"),"Y","N")
E12	E12	=IF(OR(IF(COUNTIFS(Sheet4!C3:J3,"Estelle",Sheet4!C4:J4,"-",Sheet4!C11:J11,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!D3:K3,"Estelle",Sheet4!C4:J4,"+",Sheet4!C11:J11,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")
D13	D13	=IF(AND(IF(COUNTIFS(Sheet4!C2:J2,"Sampson",Sheet4!C3:J3,"-",Sheet4!C12:J12,">0"),"N","Y")="Y",IF(OR(IF(COUNTIFS(Sheet4!C4:J4,"Sampson",Sheet4!C5:J5,"-",Sheet4!C12:J12,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!D4:K4,"Sampson",Sheet4!C5:J5,"+",Sheet4!C12:J12,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")="Y"),"Y","N")
E13	E13	=IF(OR(IF(COUNTIFS(Sheet4!C4:J4,"Sampson",Sheet4!C5:J5,"-",Sheet4!C12:J12,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!D4:K4,"Sampson",Sheet4!C5:J5,"+",Sheet4!C12:J12,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")
D14	D14	=IF(AND(IF(COUNTIFS(Sheet4!C3:J3,"Simpleton",Sheet4!C4:J4,"-",Sheet4!C13:J13,">0"),"N","Y")="Y",IF(OR(IF(COUNTIFS(Sheet4!C5:J5,"Simpleton",Sheet4!C6:J6,"-",Sheet4!C13:J13,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!D5:K5,"Simpleton",Sheet4!C6:J6,"+",Sheet4!C13:J13,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")="Y"),"Y","N")
E14	E14	=IF(OR(IF(COUNTIFS(Sheet4!C5:J5,"Simpleton",Sheet4!C6:J6,"-",Sheet4!C13:J13,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!D5:K5,"Simpleton",Sheet4!C6:J6,"+",Sheet4!C13:J13,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")
D15	D15	=IF(AND(IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"-",Sheet4!C14:J14,">0"),"N","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Trex",Sheet4!C3:J3,"-",Sheet4!C14:J14,">0"),"N","Y")="Y",IF(AND(IF(OR(IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"-",Sheet4!C14:J14,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"+",Sheet4!C14:J14,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Trex",Sheet4!C3:J3,"-",Sheet4!C14:J14,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Trex",Sheet4!C3:J3,"+",Sheet4!C14:J14,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")="Y"),"Y","Not Tested")="Y"),"Y","N")
E15	E15	=IF(AND(IF(OR(IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"-",Sheet4!C13:J13,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"+",Sheet4!C13:J13,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Trex",Sheet4!C3:J3,"-",Sheet4!C13:J13,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Trex",Sheet4!C3:J3,"+",Sheet4!C13:J13,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")="Y"),"Y","Not Tested")
D16	D16	=IF(AND(IF(COUNTIFS(Sheet4!C2:J2,"Trex",Sheet4!C3:J3,"-",Sheet4!C15:J15,">0"),"N","Y")="Y",IF(OR(IF(COUNTIFS(Sheet4!C2:J2,"Estelle",Sheet4!C3:J3,"-",Sheet4!C15:J15,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!D2:K2,"Estelle",Sheet4!C3:J3,"+",Sheet4!C15:J15,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")="Y"),"Y","N")
E16	E16	=IF(OR(IF(COUNTIFS(Sheet4!C2:J2,"EstelleTrex",Sheet4!C3:J3,"-",Sheet4!C15:J15,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!D2:K2,"Trex",Sheet4!C3:J3,"+",Sheet4!C15:J15,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")
D17	D17	=IF(AND(IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"-",Sheet4!C16:J16,">0"),"N","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Sampson",Sheet4!C3:J3,"-",Sheet4!C16:J16,">0"),"N","Y")="Y",IF(AND(IF(OR(IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"-",Sheet4!C16:J16,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"+",Sheet4!C16:J16,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Sampson",Sheet4!C3:J3,"-",Sheet4!C16:J16,"=0"),"Not Tested","Y")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Sampson",Sheet4!C3:J3,"+",Sheet4!C16:J16,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")="Y"),"Y","Not Tested")="Y"),"Y","N")
E17	E17	=IF(AND(IF(OR(IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"-",Sheet4!C16:J16,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"+",Sheet4!C16:J16,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Sampson",Sheet4!C3:J3,"-",Sheet4!C16:J16,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Sampson",Sheet4!C3:J3,"+",Sheet4!C16:J16,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")="Y"),"Y","Not Tested")
D18	D18	=IF(AND(IF(COUNTIFS(Sheet4!C2:J2,"Sampson",Sheet4!C3:J3,"-",Sheet4!C17:J17,">0"),"Y","N")="Y",IF(COUNTIFS(Sheet4!C2:J2,"Sampson",Sheet4!C3:J3,"-",Sheet4!C17:J17,">0"),"Y","N")="Y",IF(AND(IF(OR(IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"-",Sheet4!C17:J17,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"+",Sheet4!C17:J17,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Sampson",Sheet4!C3:J3,"-",Sheet4!C17:J17,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Sampson",Sheet4!C3:J3,"+",Sheet4!C17:J17,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")="Y"),"Y","Not Tested")="Y"),"Y","N")
E18	E18	=IF(AND(IF(OR(IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"-",Sheet4!C17:J17,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Simpleton",Sheet4!C3:J3,"+",Sheet4!C17:J17,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Sampson",Sheet4!C3:J3,"-",Sheet4!C17:J17,"=0"),"Not Tested","Y")="Y", IF(COUNTIFS(Sheet4!C2:J2,"Sampson",Sheet4!C3:J3,"+",Sheet4!C17:J17,"=0"),"Not Tested","Y")="Y"),"Y","Not Tested")="Y"),"Y","Not Tested")

 

[Nlhicks]

Please oh please can someone help me with this? I really need to see if there is a solution to this problem. My formulas are really 1530 lines long and if I have to repeat them for every column it is going to take forever. If there is a simple way to capture each run using the same genric formulas for each run that would be brilliant.

 

[Peter_SSs]

Duplicate to: Can a macro repeat the formulas and lookups in Run One for Run Two on this example or do I need to rewrite the formula for every run?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.