S smskater Dec 22, 2004 #1 Is there a way of using a list from another worksheet without having to bring the list into the current worksheet?
Is there a way of using a list from another worksheet without having to bring the list into the current worksheet?
B Biff Dec 22, 2004 #2 Hi! Use a defined name. Sheet2!A1:A10 named List Data validation Allow list Source =List Biff
D Debra Dalgleish Dec 22, 2004 #3 If you name the list on the other sheet, you can refer to it by name in the data validation dialog box. There are instructions here: http://www.contextures.com/xlDataVal01.html
If you name the list on the other sheet, you can refer to it by name in the data validation dialog box. There are instructions here: http://www.contextures.com/xlDataVal01.html
S smskater Dec 24, 2004 #4 If you name the list on the other sheet, you can refer to it by name in the data validation dialog box. There are instructions here: http://www.contextures.com/xlDataVal01.html Click to expand... Thank-you.
If you name the list on the other sheet, you can refer to it by name in the data validation dialog box. There are instructions here: http://www.contextures.com/xlDataVal01.html Click to expand... Thank-you.
