We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

how can I use variables in reference to external cell [closed]

asked 2014-02-06 15:44:19 +0200

hendis gravatar image


I have a LibO/Calc template that contains my company's timesheet. I want to include last week's hours on this week's timesheetby putting a formula in the template.

I need to refer to last week's timesheet (external reference), but since the W/E date is part of the filename, the name changes each week.

How can I obtain the "Total hours" value from a past LibO/Calc worksheet?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 07:10:00.687430

1 Answer

Sort by » oldest newest most voted

answered 2014-02-06 21:21:33 +0200

m.a.riosv gravatar image

You can create any reference with INDIRECT(a) function.
a: can be a text composing the link or a cell reference with the composed link as text.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-02-06 15:44:19 +0200

Seen: 171 times

Last updated: Feb 06 '14