D Don Guillett Sep 1, 2009 #2 e: how do I share data validation lists between worksheets? In the future please put your subject in the subject line and question in the BODY of the msg. make a list somewhere and NAME it something like vallist. then =vallist
e: how do I share data validation lists between worksheets? In the future please put your subject in the subject line and question in the BODY of the msg. make a list somewhere and NAME it something like vallist. then =vallist
D Dave Peterson Sep 1, 2009 #3 I'd start at Debra Dalgleish's site: http://contextures.com/xlDataVal01.html#Name DL101 wrote:
S Sean Timmons Sep 1, 2009 #4 That is, highlight the list, Insert > Name > Define and give it a name there.
D Don Guillett Sep 1, 2009 #5 Or, simply select the range and use the name box unless you want it to be dynamic. Then use a formula such as offset to define your range name.
Or, simply select the range and use the name box unless you want it to be dynamic. Then use a formula such as offset to define your range name.
D DL101 Sep 1, 2009 #6 Thank you so much, it's my first time using the office online community, I will definately use it again!
Thank you so much, it's my first time using the office online community, I will definately use it again!
D DL101 Sep 1, 2009 #7 Thank you so much, it's my first time using the microsoft online community, will definately use it again!
Thank you so much, it's my first time using the microsoft online community, will definately use it again!