New to Macros, probably a basic question

[jimlemond]

I have a spreadsheet with a main tab that has a variety of fields for the user to fill out. One of them is "Supervisor" (B5) and at the end I have a "Submit" button. Once I click the Submit button, I would like to be taken to the tab that corresponds with the name in B5. For instance, if B5 = "Jim" then go to the tab titled "Jim" would be the goal.

Cursory Google searches are giving me what looks to be way more complex options... but I am new to macros so everything seems a bit complex.

Any help would be much appreciated!!

 

[DataBlake]

Sub CommandButton1_Click()
Dim sString as string
sString = ActiveSheet.Range("B5").Value

Sheets(sString).Activate
End Sub

untested but let me know if that works

 

[juddaaaa]

How's this

Sub GotoSheet()

    Sheets(ActiveSheet.Range("B5").Value).Activate

End Sub

 

[jimlemond]

That would do the trick, thank you! Do either of you have any recommendations on how to start really learning this stuff, resources, books, etc.?

 

[DataBlake]

That would do the trick, thank you! Do either of you have any recommendations on how to start really learning this stuff, resources, books, etc.?

try this post

Splitting Single Column Data Into Three

Hi All! I am having data in a single column ..nearly 10,000 cells.. column A 1 FLOWERS ROSE JASMIN TULIP 2 DOGS BULLDOG GERMANSHEPHERED I Would like to split this data AS Column A Column B Column C 1 FLOWERS ROSE 1 FLOWERS JASMIN 1...

www.mrexcel.com