I need help with vba code for file called 2020 NFL Playoffs Brackets

%3CLINGO-SUB%20id%3D%22lingo-sub-2832071%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20with%20vba%20code%20for%20file%20called%202020%20NFL%20Playoffs%20Brackets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2832071%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F322399%22%20target%3D%22_blank%22%3E%40sf49ers%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20%26nbsp%3Balways%20tempted%20to%20see%20if%20formulas%20alone%20can%20resolve%20situations%20where%20people%20think%20that%20VBA%20is%20needed.%20Check%20out%20the%20VBA-free%20solution%20I%20created%20in%20your%20sheet%20%22NFL%20Playoffs%20Brackets%22%20for%202020.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFormulas%20alone%20in%20the%20various%20fields.%20When%20you%20enter%20the%20scores%20for%20the%20ones%20that%20are%20currently%20blank%2C%20the%20names%20of%20the%20winning%20teams%20will%20appear%3B%20until%20then%2C%20they'll%20remain%20blank.%20Formulas%20alone.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20formulas%20are%20consistent%2C%20but%20because%20the%20formatting%20has%20the%20relative%20positions%20of%20the%20teams%20in%20prior%20brackets%20in%20different%20positions%20vis-a-vis%20the%20result%20line%2C%20I%20was%20not%20always%20able%20to%20simply%20copy%20from%20one%20winner's%20line%20to%20another......%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2832089%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20with%20vba%20code%20for%20file%20called%202020%20NFL%20Playoffs%20Brackets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2832089%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20formulas%20is%20not%20correct..%20you%20can%20look%20at%20the%20worksheet%20called%20NFL%20Playoffs%20Result%20Brackets.%20That%20worksheet%20you%20put%20formulas%20should%20look%20like%20on%20worksheet%20NFL%20Playoffs%20Result%20Brackets%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20want%20with%20the%20seeds%20number%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20vba%20code%20instead%20of%20formulas%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20You%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2832261%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20with%20vba%20code%20for%20file%20called%202020%20NFL%20Playoffs%20Brackets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2832261%22%20slang%3D%22en-US%22%3EFormulas%20could%20do%20it%2C%20I%20will%20still%20contend.%20I'm%20not%20a%20football%20fan%20so%20made%20some%20assumptions%20that%20were%20clearly%20wrong.%20I%20assumed%2C%20for%20example%2C%20based%20on%20tennis%20brackets--HOW%2C%20I%20thought%2C%20brackets%20work--that%20the%20winner%20of%20here%20Colts%2FBills%20match%20would%20go%20into%20the%20slot%20against%20the%20Chiefs.%20What%20was%20the%20heuristic%20that%20brought%20the%20Browns%20up%20there%20in%20your%20%22right%20answer%22--whatever%20it%20is%20isn't%20apparent%2C%20but%20could%20be%20incorporated%20into%20a%20formula.%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20fact%2C%20in%20order%20to%20write%20VBA%20code%2C%20somebody%20is%20going%20to%20have%20to%20know%20what%20that%20heuristic%20is%20as%20well.%20You%20may%20think%20it's%20obvious%2C%20and%20maybe%20it%20is%20to%20football%20fans%2C%20but%20just%20showing%20it%20as%20%22the%20correct%20answer%22%20doesn't%20explain%20WHY%20it's%20the%20correct%20answer.%3CBR%20%2F%3E%3CBR%20%2F%3EAnyway%2C%20I%20wish%20you%20well.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2832036%22%20slang%3D%22en-US%22%3EI%20need%20help%20with%20vba%20code%20for%20file%20called%202020%20NFL%20Playoffs%20Brackets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2832036%22%20slang%3D%22en-US%22%3E%3CP%3ETake%20look%20at%20The%20file%20called%202019%20NFL%20Playoffs%20brackets%20has%20vba%20code%20fist.%20The%20code%20on%20that%20put%20on%20file%20called%202020%20NFL%20Playoffs%20Brackets%20has%20no%20vba%20code%20with%20new%20codes.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2020%20NFL%20Playoffs%20Brackets%20have%203%20worksheets.%3C%2FP%3EPicture%20Of%20Brackets%20By%20Rounds%20show%20what%20should%20happen%20NFL%26nbsp%3BPlayoffs%20Result%20Brackets%20show%20you%20what%20did%20happen%20last%20year%20playoffs.%20I%20put%20all%20data%20manually.%20NFL%20Playoffs%20Brackets%20No%20Vba%26nbsp%3B%20%26nbsp%3BI%20need%20help%20adding%20vba%20code%20on%20this%20worksheet.%20I%20also%20want%20upate%26nbsp%3B%20automatically%20when%20I%26nbsp%3B%20put%20score%20in.%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2832036%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Take look at The file called 2019 NFL Playoffs brackets has vba code fist. The code on that put on file called 2020 NFL Playoffs Brackets has no vba code with new codes. 

 

2020 NFL Playoffs Brackets have 3 worksheets.

  1. Picture Of Brackets By Rounds show what should happen
  2. NFL Playoffs Result Brackets show you what did happen last year playoffs. I put all data manually.
  3. NFL Playoffs Brackets No Vba   I need help adding vba code on this worksheet. I also want upate  automatically when I  put score in.

 

Thanks you

 

 

4 Replies

@sf49ers164480 

 

I'm  always tempted to see if formulas alone can resolve situations where people think that VBA is needed. Check out the VBA-free solution I created in your sheet "NFL Playoffs Brackets" for 2020.

 

Formulas alone in the various fields. When you enter the scores for the ones that are currently blank, the names of the winning teams will appear; until then, they'll remain blank. Formulas alone.

 

The formulas are consistent, but because the formatting has the relative positions of the teams in prior brackets in different positions vis-a-vis the result line, I was not always able to simply copy from one winner's line to another......

The formulas is not correct.. you can look at the worksheet called NFL Playoffs Result Brackets. That worksheet you put formulas should look like on worksheet NFL Playoffs Result Brackets

 

 

I also want with the seeds number 

 

 

I want vba code instead of formulas

Thanks You

Formulas could do it, I will still contend. I'm not a football fan so made some assumptions that were clearly wrong. I assumed, for example, based on tennis brackets--HOW, I thought, brackets work--that the winner of here Colts/Bills match would go into the slot against the Chiefs. What was the heuristic that brought the Browns up there in your "right answer"--whatever it is isn't apparent, but could be incorporated into a formula.

In fact, in order to write VBA code, somebody is going to have to know what that heuristic is as well. You may think it's obvious, and maybe it is to football fans, but just showing it as "the correct answer" doesn't explain WHY it's the correct answer.

Anyway, I wish you well.
I still need help from somebody that that know about NFL football playoffs.