Help with validation functions

C

Cookie S.

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?
 
J

Jim Thomlinson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data validation list using filtered range 3
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data Validation - Cell Colour 3
Filling Out Cells Based on Data Validation 1
Validation drop down arrow list disappeared 2
Having a cell show X but read something else? 4
Filtered drop down list 2
data - validation - list question 2

Top