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 4: Click on the worksheet name where you have the lists.

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
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Playlists:

Social media:

[abidhussainmh]

Love you....😘😘. I found the video I wanted with great difficulty

[aklivebhakti]

How can we go same If i use single button use to go on specific sheet as value mention in A2

[Fazwaans]

thanks for sharing your knowledge with everyone, Can you kindly explain how do this option in VBA codes, Thank

[FMITech]

Thanks for this video sir.. More wins, love your channel.

But pls what of drop down link to a specific sheets in another workbook.. place is there way out on this make a video, it's urgent sir, thanks.

[shabarieshwarprasad]

You are clicking on "January" in the dropdown and the January sheet opens up but why does it show "May" in the dropdown when this action is performed?

[amanimahnabi]

Hi, Can i do this to hidden sheet? So once i select the sheet from the drop list the hidden sheet open and closed once i chose other one ? 😢

[saurabhkush]

Like this if I want to open word file if possible then please make a video on this topic.

[tommychitkoko]

It would be nice if you could share file.

[_DP_]

I applied what you've demonstrated, and initially it works great. However, if I save as .xlsm, close the file, turn off the computer, and go back to the file the next day, it no longer works. Any ideas why?

[biancasilva]

Hi, some of the names in the drop down work and some don’t. Why would that happen? Is there anything I need to change on the code ?

[manin]

Hello ... I dont want all sheets to be visible on drop down list.... I want to create a combo-box with only particular sheet... For example :if i have 20 sheets.. I want to display and show only 15 sheets... Do u have any idea what code can i sync? Please reply.. Thank you

[ramanndewan]

I am getting an error with this code
and its not running

[SlapshockPlays]

I get an error saying:

Compile error:
Block If without End If

😑

[sanyamirza]

I have typed the same code but didn't work for me

[AbdulKarim-msxb]

sorry sir you teach us very very fast next time always remember for beginners but this was very good

[mohamadsiddeek]

Thanks again Allah bless you and how is your mother I will contact by Facebook
Thanks