Help with validation functions

  • Thread starter Thread starter Cookie S.
  • Start date Start date
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?
 
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
 
Back
Top