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!

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

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
>

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