auto insert worksheet name in dynamic named range

M

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
 
D

Dave Peterson

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

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
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top