Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic name range for use in data validation
I'm trying to include a drop down data validation in a series of cells on 1
sheet, which generates the list based on a 'library' list in a 'library' tab. The idea is that they change the library if they want to add a new item rather than introducing new items all over th place. Is there a simple way to have the list generated from a dynamic range? I.e. the list is initally from A1:A5, but if the user goes into the library tab and adds an item in A6, or inserts a row and enters data, the data validation list picks this up? (For note I've already got macros on this excel sheet based on changeevents.) Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation via Dependent List defined by Dynamic Range | Excel Discussion (Misc queries) | |||
dynamic range and data validation | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation drop downs don't recognize dynamic named range | Excel Discussion (Misc queries) | |||
Dynamic Range, Data Validation and Address, Match and Offset Funct | Excel Worksheet Functions |