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
|