| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I share data validation lists between worksheets?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I share data validation lists between worksheets?
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 -- Don Guillett Microsoft MVP Excel SalesAid Software "DL101" wrote in message ... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I share data validation lists between worksheets?
That is, highlight the list, Insert Name Define and give it a name there.
"Don Guillett" wrote: 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 -- Don Guillett Microsoft MVP Excel SalesAid Software "DL101" wrote in message ... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I share data validation lists between worksheets?
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. -- Don Guillett Microsoft MVP Excel SalesAid Software "Sean Timmons" wrote in message ... That is, highlight the list, Insert Name Define and give it a name there. "Don Guillett" wrote: 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 -- Don Guillett Microsoft MVP Excel SalesAid Software "DL101" wrote in message ... |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I share data validation lists between worksheets?
Thank you so much, it's my first time using the microsoft online community,
will definately use it again! "Don Guillett" wrote: 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. -- Don Guillett Microsoft MVP Excel SalesAid Software "Sean Timmons" wrote in message ... That is, highlight the list, Insert Name Define and give it a name there. "Don Guillett" wrote: 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 -- Don Guillett Microsoft MVP Excel SalesAid Software "DL101" wrote in message ... |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I share data validation lists between worksheets?
I'd start at Debra Dalgleish's site:
http://contextures.com/xlDataVal01.html#Name DL101 wrote: -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I share data validation lists between worksheets?
Thank you so much, it's my first time using the office online community, I
will definately use it again! "Dave Peterson" wrote: I'd start at Debra Dalgleish's site: http://contextures.com/xlDataVal01.html#Name DL101 wrote: -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
| Show do I share a dynamic list for data validation? | Excel Discussion (Misc queries) | |||
| Data Validation with Lists | Excel Discussion (Misc queries) | |||
| How do I share data in different worksheets? | Excel Worksheet Functions | |||
| How to share data between worksheets? | Excel Worksheet Functions | |||
Hybrid Mode
