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
 

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

How do I have a cell value define a dynamic named range? 15
Set non-continuous PrintArea via Function / Name 0
Excel VBA 1
using a defined Name in a function 2
Dynamic Named Ranges 3
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Question on Named range with formula 2
Reference to a Defined Name in another Workbook 1

Back
Top