Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting data with an imbedded list
I have a list of data with multiple columns and one field has a list created
using the validation function. If a resort the document, it seems like the list logic stays right where it was created. Is this a known problem or do I possibly have something set incorrectly? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting data with an imbedded list
Nothing you can do for it AFAIK
The DV list is in the cell. When you do a sort, cells are not moved, just the data moves. Gord Dibben MS Excel MVP On Thu, 14 Dec 2006 12:07:00 -0800, Jasonw151 wrote: I have a list of data with multiple columns and one field has a list created using the validation function. If a resort the document, it seems like the list logic stays right where it was created. Is this a known problem or do I possibly have something set incorrectly? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Update of Dropdown List Box data | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Sorting from a list with data on different cells | Excel Discussion (Misc queries) | |||
matching a sorting the exact value in the data list | Excel Discussion (Misc queries) |