Power Query is the way to go if you want dynamic data. It’s built into Excel and doesn’t require coding. Just go to Data > Get Data > From Web, enter the URL, and load it.
If you’re just looking to open a site, HYPERLINK is simplest. But if you move the file, hyperlinks might break unless you use full URLs (like https:// not just www.).
VBA’s not as scary as it seems, but yeah, maybe overkill for this.
If you’re just looking to open a site, HYPERLINK is simplest. But if you move the file, hyperlinks might break unless you use full URLs (like https:// not just www.).
VBA’s not as scary as it seems, but yeah, maybe overkill for this.