View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DRandolph
 
Posts: n/a
Default how can i use concatenate to create a linking formula?

I receive daily reports from the people that work for me. The files are
saved in a known location and a known naming structure (initials - date.xls)

In a summary report I CONCATENATE their initials and the date along with a
path but cannot get the INDIRECT command to recognize the text line.

Any help would be greatly appreciated.

David