|
| Sheet:External Links will get you started. Must remember to hit enter after entering or pasting web address. I have attached a spreadsheet with a external link to show two possibilities. Also attached are screenshots of relevant dialog boxes, may or may not be in order. I usually pull link into a separate sheet or file and then retrieve data using a lookup function. Into the weeds here and above my knowledge, but many websites seem to be using javascript to produce tables and I am unable to retrieve information. Calc requires a named range in the link. Sometimes it is easier to copy and paste. Attached spreadsheet shows both methods.
(Screenshot from 2023-08-09 22-32-31 (full).png)
(Screenshot from 2023-08-09 22-33-25 (full).png)
(Screenshot from 2023-08-09 22-53-32 (full).png)
Attachments ---------------- Example.ods (39KB - 395 downloads) Screenshot from 2023-08-09 22-32-31 (full).png (23KB - 287 downloads) Screenshot from 2023-08-09 22-33-25 (full).png (29KB - 284 downloads) Screenshot from 2023-08-09 22-53-32 (full).png (46KB - 258 downloads)
| |
|