J
Jeff
Does a data list for cell valadation have to be on the same work sheet?
Thanks!
Thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Carim
No ... As long as you Insert Name Define your range ...
HTH
HTH
J
Jarek Kujawa
yes, in Excel 2003
J
Jeff
G
Gord Dibben
Incorrect Jarek
If you first give the list on sheet2 a defined name like MyName you can use
that defined name in sheet1 DV list source
Type =MyName into the source refedit dialog.
Gord
If you first give the list on sheet2 a defined name like MyName you can use
that defined name in sheet1 DV list source
Type =MyName into the source refedit dialog.
Gord