Drop down list to navigate between sheets

[LoganV]

Hi everyone, first of all sorry if my english is not really good. My first language is spanish ?
I want to do a drop down list to navigate between sheets. But i want to start in some determinate sheets and finish in other determinate sheets.
Ive got those sheets:

Menu, Business Generator,[New Business],Business spending, Other sheets with no interest...

In the "Businness Generator" sheet there's a macro that copies its information in a new sheet call Business1. Then if i press again the macro then it will be another Business2 and my sheets will be like this:

Menu, Business Generator,Business1,Business2, [New Business],Business spending, Other sheets with no interest...

etc.

So i want to create a list in the menu with wich i can navigate between only business sheets. In the previous example, a drop down list that shows: Business1,Business2. Only those one.
Do you now how can i do that?
Thanks ?

 

[LoganV]

Anyone?

 

[My Aswer Is This]

I looked at your post and your English is very good. But I got lost understanding what you wanted.

I'm thinking you want a data validation list of sheet names so if you select "Master" you will be taken to sheet named "Master"

But I get lost when you start naming the sheets you want listed and on what sheet you want the list.

Could you please explain again what your wanting and lets just do one at a time.

So I would suggest putting the sheet names you want taken to in A Range like B1:B15

And then tell me the sheet name and the Range where the sheet names are.

 

[LoganV]

I looked at your post and your English is very good. But I got lost understanding what you wanted.

I'm thinking you want a data validation list of sheet names so if you select "Master" you will be taken to sheet named "Master"

But I get lost when you start naming the sheets you want listed and on what sheet you want the list.

Could you please explain again what your wanting and lets just do one at a time.

So I would suggest putting the sheet names you want taken to in A Range like B1:B15

And then tell me the sheet name and the Range where the sheet names are.

Yes thats exactly what a want. If i want to go to the sheet "A" i want to select it in the list and then be taken to this sheet.
You say to put my sheets in a range but i dont know how many sheets will i have.
I have a sheet named "BusinessGenerator" and in this ive got a macro that duplicates it, so if i click once on the macro then ill have just one more sheet: "BusinessGenerator (1)" But if i click, for example, 5 times on the macro, then ill have 5 more sheets named: "BussinesGenerator (1)", "BusinessGenerator (2)",...,"BusinessGenerator (5)"
Thats why i cant put their names in a range cause i dont know how many sheets will i have
Did i explained? ?

 

[Jaafar Tribak]

And where will the drop down list be located ?

 

[My Aswer Is This]

So do you want all the sheet names put into the DataValidation list?

I will tell you what I already use.

I have a Userform with a Listbox.
When I open the Userform all sheet names are loaded into the UserForm Listbox.
And when I click on a name in the listbox I'm taken to that sheet.
The Userform is opened using Modeless mode which means you can work on your worksheet like normal but keep the Userform Displayed.

My Userform is very narrow in width with just the Listbox showing this way it does not hide any of my sheet. I also have one little button on the Userform which when pressed closes the Userform.

So as long as the Userform is displayed all you do is click on the listbox sheet name you want to go to.

So all sheet names are always displayed in the Listbox every time you open the Userform.

Would something like this work for you.

 

[My Aswer Is This]

And I have my Userform in my Excel Personal folder which makes it available to be opened into any workbook. I use a shortcut key or a script assigned to my Upper Menu Bar to open the userform.