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?

[Nlhicks]

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]

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

 

[Nlhicks]

They are the exact same formulas except that they shift to the next run so every time they shift by 8.

 

[Nlhicks]

Is this impossible for everyone? What can I do to make it possible?

 

[Nlhicks]

Anyone?

 

[Nlhicks]

What if I created a formula page with all of the formulas written generically with variables instead of values or ranges? Could a macro be written then that would cycle through as many times as required to capture all data including incoming data that will be added at a later time?

 

[Nlhicks]

No one?