 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2006Updating a named range
How can I automatically have a named range populate? Example: In column 1, I have a list of 6 employees named "employees". I added another employee. How can I get my named range "employees" to include the new employee. Hi Go to Insert/Name/Define and you can change it there. An alternative is to use a dynamic range - so your range will expand on its own. See here: http://www.contextures.com/xlNames01.html#Dynamic for more info. Andy. > How can I automatically have a named range populate? Example: In column > 1, > I have a list of 6 employees named "employees". I added another employee. > How can I get my named range "employees" to include the new employee. I tried the dynamic range which is what I was looking for. Works great. Thanks a bunch... > How can I automatically have a named range populate? Example: In column 1, > I have a list of 6 employees named "employees". I added another employee. > How can I get my named range "employees" to include the new employee. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.