| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Making a drop down list read info from another tab / worksheet
Hi All,
Would anyone know if it's possible to read info into a drop down from a list in another tab in a spreadsheet - and if so how to do it? I'm not sure if this is possible, but one of my managers is sure it can be done easily. Rgds, Paul |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Making a drop down list read info from another tab / worksheet
See:
http://www.dailydoseofexcel.com/arch...#comment-34646 under heading Conditional data validation Hope this helps "Paul" wrote: Hi All, Would anyone know if it's possible to read info into a drop down from a list in another tab in a spreadsheet - and if so how to do it? I'm not sure if this is possible, but one of my managers is sure it can be done easily. Rgds, Paul |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Making a drop down list read info from another tab / worksheet
Hi Paul
take a look at Debra Dalgleish's site. It contains all the information you want about Data validation http://www.contextures.com/xlDataVal01.html -- Regards Roger Govier "Paul" wrote in message ... Hi All, Would anyone know if it's possible to read info into a drop down from a list in another tab in a spreadsheet - and if so how to do it? I'm not sure if this is possible, but one of my managers is sure it can be done easily. Rgds, Paul |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Making a drop down list read info from another tab / worksheet
Thanks Ron,
It works great! Paul "Ron@Buy" wrote: See: http://www.dailydoseofexcel.com/arch...#comment-34646 under heading Conditional data validation Hope this helps "Paul" wrote: Hi All, Would anyone know if it's possible to read info into a drop down from a list in another tab in a spreadsheet - and if so how to do it? I'm not sure if this is possible, but one of my managers is sure it can be done easily. Rgds, Paul |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Making a drop down list read info from another tab / worksheet
Glad I could help, thanks for the feedback
"Paul" wrote: Thanks Ron, It works great! Paul "Ron@Buy" wrote: See: http://www.dailydoseofexcel.com/arch...#comment-34646 under heading Conditional data validation Hope this helps "Paul" wrote: Hi All, Would anyone know if it's possible to read info into a drop down from a list in another tab in a spreadsheet - and if so how to do it? I'm not sure if this is possible, but one of my managers is sure it can be done easily. Rgds, Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making wider drop down List for Filter | Excel Worksheet Functions | |||
| Making data validation drop down list wider | Excel Discussion (Misc queries) | |||
| Limit drop down list and linking to other info | Excel Worksheet Functions | |||
| Making a drop down list/column | Excel Worksheet Functions | |||
| Prefill cust info from drop list into other cells | Excel Worksheet Functions | |||
Linear Mode
