defining lists

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...
 
R

Ron de Bruin

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

Excel does not accept text format! 0
How do I have a cell value define a dynamic named range? 15
Duplicate hashtags in OneNote 0
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Weigh tasks 0
Reference to a Defined Name in another Workbook 1
using a defined Name in a function 2
How to create bulleted to-do list using two styles? 5

Top