Hello.

Im trying to adapt a formula destination to cell.

I have a formula on cell B2 that is directed do other excel file, It appears like [1.xlsx] 1 being the name of the other file.

What I am trying to is make something like:

cell A2 = 1
and ["A2".xlsx]

so whenever I change the A2 cell, the destination also changes.

Thank you in advance.