Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with validation functions
I am cutting information from one sheet and inserting cut cells into a second
sheet. When I do this, the drop down list set up for one of the columns, doesn't work anymore. This used to work perfectly but for some reason it isn't now. The empty cells below the "inserted cut cell" have the drop down list arrow but when I insert the cut cell from the other sheet, it quits working. Anybody have any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with validation functions
Cookie S. wrote:
I am cutting information from one sheet and inserting cut cells into a second sheet. When I do this, the drop down list set up for one of the columns, doesn't work anymore. This used to work perfectly but for some reason it isn't now. The empty cells below the "inserted cut cell" have the drop down list arrow but when I insert the cut cell from the other sheet, it quits working. Anybody have any suggestions? Hi , Data Validation will not work when cells are pasted onto it.The dropdown choice means that there must be a validation for those cells. Thanks -- Message posted via http://www.officekb.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with validation functions
Data validation lists require the the source cells for the list be on the
same tab as the list itself. So when you copy the validation cells to a new worksheet the list is lost as it is on the other worksheet. The way around this is to use a named range for your source list. The named range gets around the same sheet limitation of data validation lists... Check out http://www.cpearson.com/excel/DefinedNames.aspx looking at Defined Names And Conditional Formatting And Data Validation Use Insert | Name | Define to create named ranges -- HTH... Jim Thomlinson "Cookie S." wrote: I am cutting information from one sheet and inserting cut cells into a second sheet. When I do this, the drop down list set up for one of the columns, doesn't work anymore. This used to work perfectly but for some reason it isn't now. The empty cells below the "inserted cut cell" have the drop down list arrow but when I insert the cut cell from the other sheet, it quits working. Anybody have any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data Validation Combine Functions | Excel Worksheet Functions | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Using custom functions within custom validation | Excel Discussion (Misc queries) |