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 |
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 |
All times are GMT +1. The time now is 08:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com