Circular Reference Error

[VinceF]

I hope that I can explain this better than the last attempt.
I've tried to move data around and also tried helper cells...nothing worked and I keep getting the circular error message.
Right now I have to manually input the adjusted number in the appropriate cell, I'm hoping there's a VBA code to accomplish this.
This is a golf game that tracks the players results and adjust accordingly.

"MAIN" sheet cell AL7 will be where the command button will reside to execute the VBA code

"PLAYER QUOTA HISTORY" sheet
E2 is the Round# that is being played, this number will be between 1 and 40
B5:B141 show the players results from the round pulled from the "MAIN" sheet
G5:G141 is the players adjusted quota
H5:H141 is where the adjusted quota number would go for ROUND 1
I5:I141 is where the adjusted quota number would go for ROUND 2 and so forth until ROUND 40
F2 If a player is over quota you add to his current adjusted quota number, under quota you subtract from his current adjusted quota number

Sorry about Column F2 for being so wide...not sure why it did it when I copied the mini table using XL2bb

So in essence, I'd like to have the number in G5:G141 adjusted according to the schedule in F2 and reported in the Round# that was played.


Example from the sheet below, ROUND 1
Adam Altman shows +8 in cell B5 His adjusted quota # in cell G5 is 28 according to the schedule in F2 since he was over quota the adjusted number to go into cell H5 would be +2 points or "30" this becomes his new current adjustment quota number for the next round that will be played.
Anthony Stefani shows -10 in cell B5 His adjusted quota # in cell G5 is 27 according to the schedule in F2 since he was under quota the adjusted number to go into cell H5 would be -3 points or "24"

I'd appreciate any assistance that you can offer.
VinceF
Excel 2016

1-20 INDIANWOOD QUOTA - SKINS.xlsm
	B	C	D	E	F	G	H	I	J	K
2	MAIN PAGE		INSTRUCTIONS TO ADD PLAYER	1	ADJUST ACCORDING TO "POINTS" B5:B141 ( -2 TO +2 ) NO ADJUSTMENT ( -3 TO +6 ) +1 OR -1 POINT ( -7 TO +9 ) +2 OR -2 POINTS ( -10 TO +10 ) OR MORE +3 OR -3 POINTS
3				CURRENT	STARTING	ADJUSTED	ROUND	ROUND	ROUND	ROUND
4	POINTS	ROUND	PLAYER	HDCP	QUOTA	QUOTA	1	2	3	4
5	+8	72	ADAM ALTMAN	8	28	28
6			ADAM PIOCH
7			ALLEN PRAET
8	-10	91	ANTHONY STEFANI	9	27	27
9	+3	80	AUSTIN ROMZEK	12	24	24
10			BILL KNIGHT
11	-4	85	BILLY UHL	10	26	26
12			BRANDON LESKE
13	+10	76	BRIAN KNOX	14	22	22
14			CHARLIE SCHULTZ
15			CHRIS KIPP
Player Quota History

Cell Formulas
Range	Formula
B5:B15	B5	=IFERROR(INDEX(Main!$AK$11:$AK$50,MATCH($D5,Main!$G$11:$G$50,0)),"")
C5:C15	C5	=IFERROR(INDEX(Main!$AI$11:$AI$50,MATCH(D5,Main!$G$11:$G$50,0)),"")
E5:E15	E5	=IFERROR(INDEX(Main!$I$11:$I$50,MATCH(D5,Main!$G$11:$G$50,0)),"")
F5:F15	F5	=IFERROR(INDEX(Main!$J$11:$J$50,MATCH(D5,Main!$G$11:$G$50,0)),"")
G5:G15	G5	=IFERROR(IF(AND($E$2=1,H5=""),F5,LOOKUP(2,1/($H5:$AK5<>""),$H5:$AK5)),"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D6:D141	Cell Value	contains "ZZZ"	text	NO
K5	Expression	=AND(ISNUMBER($B5),$E$2=4)	text	NO
I5	Expression	=AND(ISNUMBER($B5),$E$2=2)	text	NO
H5	Expression	=AND(ISNUMBER(B5),$E$2=1)	text	NO
J5	Expression	=AND(ISNUMBER($B5),$E$2=3)	text	NO
B5	Expression	=ISNUMBER(B5)	text	NO
C5	Expression	=ISNUMBER(C5)	text	NO
D6:D141	Expression	=ISNUMBER(B6)	text	NO
G5:G141	Expression	=ISTEXT(D5)	text	NO
F6:F141	Expression	=ISTEXT(D6)	text	NO
F5	Expression	=ISTEXT(D5)	text	NO
E6:E141	Expression	=ISTEXT(D6)	text	NO
E5	Expression	=ISTEXT(D5)	text	NO
D5	Expression	=ISNUMBER(B5)	text	NO
H6:H141	Expression	=AND(ISNUMBER(B6),$E$2=1)	text	NO
K6:K141	Expression	=AND(ISNUMBER($B6),$E$2=4)	text	NO
J6:J141	Expression	=AND(ISNUMBER($B6),$E$2=3)	text	NO
I6:I141	Expression	=AND(ISNUMBER($B6),$E$2=2)	text	NO
B6:C141	Expression	=ISNUMBER($B6)	text	NO
D4	Expression	=ISNUMBER(#REF!)	text	NO
H4	Expression	=AND(ISNUMBER(#REF!),$E$2=1)	text	NO
I4	Expression	=AND(ISNUMBER(#REF!),$E$2=2)	text	NO
J4	Expression	=AND(ISNUMBER(#REF!),$E$2=3)	text	NO
K4	Expression	=AND(ISNUMBER(#REF!),$E$2=4)	text	NO

 

[mumps]

You are very welcome.