How To Go to Specific Worksheet Based On Drop-down Lists In Excel

Описание: How to Go to Specific Worksheet Based on Drop-down Lists in Excel
In this advanced excel tutorial I’ll show you how you can navigate through different worksheets based on cell value, or even better, drop-down list.

This could work like a menu bar from where you can select a worksheet and move on to that worksheet. Now let’s learn how you can go to different worksheet based on cell value.

Step 1: Create a drop-down list on cell A2 (Learn how you can create Drop-down lists:    • How to Create a Drop-Down List in Excel Us...  )

Step 2: Click on the Developer tab (How to Add Developer Tab In Excel:    • How to add developer tab in excel   )

Step 3: Click on Visual Basic (Learn VBA Programming: http://bit.ly/excelvbacourse )

Step 4: Click on the worksheet name where you have the lists.

Step 5: Write the code (Please subscribe and here goes the code:   / 33440028  )

Step 6: Close the VBE or Visual Basic Editor

Step 7: Repeat the process if you need to do it on multiple worksheets.

Done. You have successfully created a drop-down list by which you can move to different worksheets.

Thanks for watching.
#GoToWorksheet #DropDownList
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
  / excel10tutorial  
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel: http://bit.ly/2oXmqsb

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Excel VBA Programming Course: http://bit.ly/excelvbacourse

Social media:
Facebook:   / excel10tutorial  
Twitter:   / excel10tutorial  
Blogger: https://excel10tutorial.blogspot.com
Tumblr:   / excel10tutorial  
Instagram:   / excel_10_tutorial  
Hubpages: https://hubpages.com/@excel10tutorial Become a member and enjoy exclusive perks while supporting the channel you love!
   / @excel10tutorial