This is hard to explain...but I have a drop down list in a worksheet.
Whatever name is chosen in the drop down list I need to show up in a
different sheet in a different work book. Can this be done? Thanks!