Captain Randy
Board Regular
- Joined
- Sep 26, 2010
- Messages
- 68
Looking at placeing a List on sheet 2 and the drop drop list box on sheet 1. How do I make the drop down list on sheet 1 read the list on sheet2 ?
Thank You in advance for your help.
Randy
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Validation List on sheet 2 drop on
- Thread starter Captain Randy
- Start date
Looking at placeing a List on sheet 2 and the drop drop list box on sheet 1. How do I make the drop down list on sheet 1 read the list on sheet2 ?
Thank You in advance for your help.
Randy
Excel Facts
VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
jeffreybrown
Well-known Member
- Joined
- Jul 28, 2004
- Messages
- 5,152
You need to create a named range
Upvote
0
Similar threads
- Solved
