Forum Discussion
create function value link
Hi, Today I use this type of link, and it's good =@'W:\_Devis\Devis 230505.xlsx'!Toto ----> Toto is a predef cell but I want to generate the link like something like this =CONCAT("@'W:\_Devis\D...
#REF.. but no problem with the destination..
I have try without concat by using &
=INDIRECT("@'W:\_Devis\Devis "&B2&".xlsx'!Toto")
same result an over idea ?
=INDIRECT("@'W:\_Devis\Devis "&B2&".xlsx'!Toto")
same result an over idea ?