defining lists

  • Thread starter Thread starter Nik Patel
  • Start date Start date
N

Nik Patel

Is there a way that I can define a list of 'valid'values
for a given cell in which the list itself is defined on a
other worksheet? I know that you can reference another
cell or a range within the same worksheet but I have lsits
defined in another one...
 
You can do this by naming the range (Ctrl-F3) on the other sheet
And use that name in the Data validation list
 
Back
Top