View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John M[_2_] John M[_2_] is offline
external usenet poster
 
Posts: 5
Default I'm trying to include a cell reference as part of an ext. link

I want to pull data from another workbook, but I want the name of the
workbook I pull from to be controlled from a drop-down in the main worksheet.
I have the drop-down part figured out, but I can't get that result
incorporated correctly into my link formula. The value in the drop down will
form part of the file name.