| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel drop list reference?
I need help with the following.? I hope someone can help me. I'm working with a drop down list on one worksheet.? When i select something from the list, i want whatever is selected to populate in another cell, on another worksheet.? Is this possible?? Please help!
EggHeadCafe - Software Developer Portal of Choice ASP.NET Data Control Series - Part 2 http://www.eggheadcafe.com/tutorials...trol-seri.aspx |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel drop list reference?
Jason - On the destination sheet, you should be able to just press the =, and
navigate back to the drop down cell and select it. Then whatever is in the drop down slection will populate the other sheet So if the drop down is on sheet 1, cell A1, then in sheet 2 in the destination cell =sheet1!A1 Regards Jason Frost wrote: I need help with the following.? I hope someone can help me. I'm working with a drop down list on one worksheet.? When i select something from the list, i want whatever is selected to populate in another cell, on another worksheet.? Is this possible?? Please help! EggHeadCafe - Software Developer Portal of Choice ASP.NET Data Control Series - Part 2 http://www.eggheadcafe.com/tutorials...trol-seri.aspx -- Matt Lynn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200911/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down list reference | Excel Discussion (Misc queries) | |||
| worksheet names in drop down list for reference | Excel Discussion (Misc queries) | |||
| Drop Down List Reference Problem | Excel Discussion (Misc queries) | |||
| How do i have one Drop down list reference another drop down list | Excel Discussion (Misc queries) | |||
| Can I create a drop-down list that will reference other drop-down | Excel Worksheet Functions | |||
Linear Mode
