View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ChEBass ChEBass is offline
external usenet poster
 
Posts: 3
Default Indirect addressing for linked file

I have a master calculation file which pulls data from a monthly data file. I
would like to use indirect addressing so I anoly change one cell each month
to point to the correct spreadsheet. I can use CONCATENATE to create
something that looks like the correct command, but I cannot make it an
executable statement to actually pull the data - it is text. Any ideas?