auto insert worksheet name in dynamic named range
 

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
--
Thank You!

auto insert worksheet name in dynamic named range
 

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



maijiuli wrote:

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
--
Thank You!

--

Dave Peterson

auto insert worksheet name in dynamic named range
 

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
--
Thank You!


"Dave Peterson" wrote:

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



maijiuli wrote:

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
--
Thank You!

--

Dave Peterson

auto insert worksheet name in dynamic named range
 

Check your other post for a way.

maijiuli wrote:

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
--
Thank You!

"Dave Peterson" wrote:

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



maijiuli wrote:

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
--
Thank You!

--

Dave Peterson


--

Dave Peterson