Ask Your Question
0

Create dynamic file reference

asked 2016-07-18 12:42:55 +0200

Bernmeister gravatar image

(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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2016-07-18 17:31:13 +0200

m.a.riosv gravatar image

=INDIRECT("'file:///Data/"&A2&".ods'#Sheet1.A10")

Be aware that INDIRECT() is a volatile function using it extensively can make a bit slower the spreadsheet.

edit flag offensive delete link more

Comments

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.

Bernmeister gravatar imageBernmeister ( 2016-07-19 00:03:47 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-07-18 12:42:55 +0200

Seen: 74 times

Last updated: Jul 18 '16