Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting changes validation
Excel 2003. Validation of input works perfectly until the worksheet is
sorted. After sorting the worksheet the validations seem to stay in their original row and column while the cells contents move according to the sort criteria. Can anyone explain please what is happening and how, when sorting, to get the each cells validation to move with the cell it is validating so that it continues to validate that cell and not the cell which is now in it's original row and column position. All help appreciated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
Sorting with data validation applied | Excel Worksheet Functions | |||
validation and sorting | Excel Discussion (Misc queries) | |||
Sorting Validation | Excel Discussion (Misc queries) |