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