I have a file that I name daily jumbo arms and then the date. I have another file that needs to be linked to this file. Im trying to use an indirect in the link {basically in another field I put ="jumbo Arms "&MONTH(N104)&" "&DAY(N104)&" "&YEAR(N104)&".xls" cell n104 is today() which gets me the actual file name and I tried to insert that via Indirect into my linked formula} but cant seem to get it right - can anyone help me?
Thanks
Thanks