drop down list

D

da

Hi
How can I create a drop down list which is on a separate worksheet but in
the same file? The name of the worksheet is Idaunits. And I want the drop
down list on a separate worksheet named WCU Sept.
Thanks
1I1A
1I1B
1I2
1I3
1I4
1I4A
1I4B
1I5
1I6
1I96
1I97
1I98
1L20
1L40
1L50
1Z2
1Z3
2I1
2I1A
2I1B
2I2
2I3
2I3B
2I4
2I4A
2I4B
2I5
2I6
2I96
2I97
2I98
2L20
2L40
2L50
2Z2
2Z3
 
L

Luke M

Goto Insert - Name - Define.
Select your range of cells with your list, and give it a name (MyRange).
Click Add, Ok out.

On your other worksheet, goto Data - Validation - List
Input the following:
=MyRange

Ok out.
 
D

da

Thank you. It worked.

Luke M said:
Goto Insert - Name - Define.
Select your range of cells with your list, and give it a name (MyRange).
Click Add, Ok out.

On your other worksheet, goto Data - Validation - List
Input the following:
=MyRange

Ok out.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down List Contains the List Header Row 1
Filtered drop down list 2
HOW TIMES A NAME IS USED IN DROP DOWN LIST 5
Create Drop Down Box populated by a List 1
Fill Drop Down with List 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
drop down list starts from blank row 5
Expanded Drop Down Box Question 2

Top