|
|
#5
05-26-2011, 01:59 PM
|
||||
|
||||
You are using Excel 2007 so you can use a Table. It will automatically expand as you add to it. In the attached example I have created a table containing a list of tools. In H4 I have used data validation to create a dropdown list. If you add a new tool to the list (C9, then C10 etc) you will see that it automatically gets added into the dropdown list.
For reference, in versions prior to Excel 2007 you could use a List (Excel 2003 only) or a dynamic named range. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 custom bullet points - stop image resizing
|
dlee388 | PowerPoint | 1 | 12-29-2009 04:47 PM |
| Sort Range | boutells | Excel | 1 | 07-15-2009 03:02 AM |
| PowerPoint Embedded Chart Objects Resizing | aeddipa | PowerPoint | 0 | 07-06-2009 09:41 AM |
|
Range Formula
|
aleksandr | Excel | 10 | 05-18-2009 12:14 PM |
| resizing a checkbox?? | aceensor | Excel | 0 | 05-10-2006 01:44 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode