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

Post a sample of the formula you are trying.

Biff

"DRandolph" wrote in message
...
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