auto insert worksheet name in dynamic named range

[maijiuli]

Hello,

I've heard of dynamic named ranges but is there something to automatically
insert the name of a newly added worksheet in the named range?

My excel file has 200 worksheets and is expanding. I've created a dynamic
name range to use as a reference to my drop down menu for easy access to the
worksheets. But I'm tired of manually adding the newly created worksheet
name to my dynamic list.

Please let me know if this is possible.

Thanks for looking,

MJ

 

[Dave Peterson]

Maybe you could just add another feature to refresh the list of worksheet names
in that range.

 

[maijiuli]

How can I do this sir? Is this a timer thing or an automatic refresh on open
thing? Or can I make a button to execute this kind of function? Please let
me know by example or if you have a website I can train myself on.

Thank you very much,

MJ

 

[Dave Peterson]

Check your other post for a way.

How can I do this sir? Is this a timer thing or an automatic refresh on open
thing? Or can I make a button to execute this kind of function? Please let
me know by example or if you have a website I can train myself on.

Thank you very much,

MJ