Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linked Lists / Data Validation - Excel 97
Hi,
I'm setting up a linked list which works nicely between single cells, however.... My columns are 1000 rows long and i really don't want to be adding in each validation individually. Is there a rather quick way for me apply the data validation taking into account the linked lists as they need to reference a specific cell and not a cell range? So can the cells E16 to E1016 be filled quickly for the data validation to reference cells D16 to D1016? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linked Lists / Data Validation - Excel 97
I don't know if this works for '97 because I only have 2003 to test with.
However, in 2003 you can highlight E16 to E1016 and perform the reference to cells D16 to D1016 once. -- Hope this helps. If this post was helpfull, please remember to click on the ''''YES'''' button at the bottom of the screen. Thanks, Gary Brown "Phendrena" wrote: Hi, I'm setting up a linked list which works nicely between single cells, however.... My columns are 1000 rows long and i really don't want to be adding in each validation individually. Is there a rather quick way for me apply the data validation taking into account the linked lists as they need to reference a specific cell and not a cell range? So can the cells E16 to E1016 be filled quickly for the data validation to reference cells D16 to D1016? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation lists | Excel Discussion (Misc queries) | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Data Validation (2 lists) | Excel Discussion (Misc queries) | |||
Data Validation with Lists | Excel Discussion (Misc queries) | |||
Data Validation Lists | Links and Linking in Excel |