Fai la tua domanda

Bernmeister's profile - attività

2016-07-19 00:03:47 +0200 ha commentato una risposta Create dynamic file reference

Thanks! Have started rolling into my spreadsheet - noticed it is slightly slower but that's fine given the time saved for me when I have to continually edit.

2016-07-19 00:02:51 +0200 received badge  Sostenitore (source)
2016-07-19 00:02:48 +0200 received badge  Studioso (source)
2016-07-18 23:35:29 +0200 received badge  Domanda gettonata (source)
2016-07-18 17:31:43 +0200 received badge  Studente (source)
2016-07-18 12:42:55 +0200 ha posto una domanda Create dynamic file reference

(originally posted on StackOverflow)

Is is possible to create a file link using the value from another cell? For example, if I ultimately want a file link

'file:///Data/AAA.ods'#Sheet1.A10

(which pulls in data from another file/sheet/cell), but instead of typing out the whole thing (because I have lots of entries) I instead have a formula which would function as

'file:///Data/[A2].ods'#Sheet1.A10

where cell A2 contains the value AAA.

Thanks in advance,

Bernmeister.