I need creating vba code.

[Legacy 420921]

red cells I want a vba code that only go that area

Get File from Link before
https://1drv.ms/x/s!AnJwxxiz0Ezpg8d44doit5nmxCco9A?e=b7ucl2

Ty Thomas

 

[Legacy 420921]

here the pictures

https://1drv.ms/u/s!AnJwxxiz0Ezpg8l_m2iaw4_-krTUsQ?e=njhqap

 

[Michael M]

More info ???

 

[Legacy 420921]

I do not have any code yet. I need help making code.

 

[Legacy 420921]

red color cells is unpick teams. i need code that go through column B and column F pick them

B3 when I press tab or enter key it will goto F3 than goto B4
B4 when I press tab or enter key it will goto F4 than goto B5
B5 when I press tab or enter key it will goto F5 than goto B6
B6 when I press tab or enter key it will goto F6 than goto B7
B7 when I press tab or enter key it will goto F7 than goto B8
B8 when I press tab or enter key it will goto F8 than goto B9
B9 when I press tab or enter key it will goto F9 than goto B10
B10 when I press tab or enter key it will goto F10 than goto B11
B11 when I press tab or enter key it will goto F11 than goto B12
B12 when I press tab or enter key it will goto F12 than goto B13
B13 when I press tab or enter key it will goto F13 than goto B14
B14 when I press tab or enter key it will goto F14 than goto B15
B15 when I press tab or enter key it will goto F15 than goto B16
B16 when I press tab or enter key it will goto F16 than goto B17
B17 when I press tab or enter key it will goto F17 than goto B18
B18 when I press tab or enter key it will goto F18

Blue color cells is unpick teams. i need code that go through column B and column F
wild card & division pick them

B3 when I press tab or enter key it will goto F3 than goto B4
B4 when I press tab or enter key it will goto F4 than goto B5
B5 when I press tab or enter key it will goto F5 than goto B6
B6 when I press tab or enter key it will goto F6

Conf Championship them
B3 when I press tab or enter key it will goto F3 than goto B4
B4 when I press tab or enter key it will goto F4

Super Bowl Pick Them
B3 when I press tab or enter key it will goto F3


TY Thomas

 

[Legacy 420921]

Private Sub Worksheet_Change(ByVal Target As Range)    Dim tabArray As Variant
    Dim i As Long
    tabArray = Array("B3", "F3", "B4", "F4", "B5", "F5", "B6", "F6", "B7", "F7", "B8", "F8", "B9", "F9", "B10", "F10", "B11", "F11", "B12", "F12", "B13", "F13", "B14", "F14", "B15", "F15", "B16", "F16", "B17", "F17", "B18", "F18")
    Application.ScreenUpdating = False
    For i = LBound(tabArray) To UBound(tabArray)
        If tabArray(i) = Target.Address(0, 0) Then
            If i = UBound(tabArray) Then
                Me.Range(tabArray(LBound(tabArray))).Select
            Else
                Me.Range(tabArray(i + 1)).Select
            End If
        End If
    Next i
    Application.ScreenUpdating = True
End Sub

it is go to f4 i want go to b4 instead

TY
Thomas

 

[Fluff]

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Please provide the cross post link(s) as per the rules.