Ask Your Question

Revision history [back]

Use formula result as Link to External Data


I think I might just be missing the simple answer but...

I'd like to import player data from a website. But I'd like to easily change what data is imported based on a calculation inside my LO Calc file.

Using concatenate I can take these inputs: Week 13 Position 1 Offset 0

and create this url link:

If you go to the website you will see this a real link with 25 rows of real player data. If you change the week or position number the web page reloads appropriately. For example: Week 13 Position 2 Offset 26

Inside calc though I have to actually update and redo each of my external links each week.

Is there a simple way to make a macro or something to save some time and effort for these steps?

Thanks so much, TC