|
drop down list
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 |
drop down list
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!* "da" wrote: 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 |
drop down list
Thank you. It worked.
"Luke M" wrote: 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!* "da" wrote: 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 |
| All times are GMT +1. The time now is 05:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com