Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-05-2012, 10:50 AM
bryanarn bryanarn is offline How do you add to a selection list? Windows 7 64bit How do you add to a selection list? Office 2010 64bit
Novice
How do you add to a selection list?
 
Join Date: Mar 2012
Posts: 4
bryanarn is on a distinguished road
Default How do you add to a selection list?

I have a selection list entered on another sheet which houses the list for my drop down selection on my first sheet.



Once I bound the list, how can I add to it at a later date without having to rename or redo the list? Is it possible?
Reply With Quote
  #2  
Old 03-05-2012, 04:05 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline How do you add to a selection list? Windows 7 32bit How do you add to a selection list? Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Welcome to the forum.

Certainly this is possible - you're using Excel 2010 so you can make use of a Table. I'll give you a step by step example and then see if you can adapt it to your needs.

Open a new workbook and put the following values in Sheet1.
A1 MyList
A2 a
A3 b
A4 c

"a","b" and "c" will be the values we want in the dropdown list. Select A1:A4, go to the Insert tab on the Ribbon and choose Table. Make sure that the "My table includes headers" option is ticked and click on OK.

A table tools design tab will appear on the ribbon. If you go on there you'll see that your table has probably been given the name "Table1".

Now go to the Formulas tab on the ribbon and click on Define Name. Give it the name "MyDVList" (without the quotes) and click on grid icon to the right of the "refers to" box and select A2:A4 on Sheet1. Excel should come up with a formula such as this:

=Table1[Column1]

Click on the grid icon again and click on OK.

Next, navigate to Sheet2 and select cell A1. On the Ribbon choose Data > Validation. In the Allow box pick "List" and in the Source box type in this:

=MyDVList

Click on OK.

Now we can look at the results. If you click on the drop down arrow on Sheet2!A1 you will see three choices - "a", "b", "c". Then go to Sheet1 and add a new value at the bottom of the table. Let's say "d" in cell A5. Go back to Sheet2!A1 and check the dropdown list. You should see that it has automatically expanded to include "d" too.
Reply With Quote
  #3  
Old 03-05-2012, 05:04 PM
bryanarn bryanarn is offline How do you add to a selection list? Windows 7 64bit How do you add to a selection list? Office 2010 64bit
Novice
How do you add to a selection list?
 
Join Date: Mar 2012
Posts: 4
bryanarn is on a distinguished road
Default

That's exactly what I needed, Colin!

Thanks for you time!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you add to a selection list? Text Box Selection GugaBFigueiredo Word 1 01-16-2012 09:04 PM
How do you add to a selection list? you cannot insert this selection into a table. cs_starter Mail Merge 2 09-08-2011 02:58 AM
How do you add to a selection list? Customer selection in Word Jackissimus Word 2 02-27-2011 12:56 PM
How do you add to a selection list? Save Selection cksm4 Word VBA 25 01-30-2011 11:44 PM
Document selection procedure kennethc Word 0 09-15-2010 02:56 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft