I have 20+ Sheets, each with a ‘Link External Data’ pulling from an external URL that changes ‘hash’ each day? Each Link will use the same common ‘hash’ that I can update in a cell and create the url specific to that page.
day1: - dv_options.j;jsessionid=bztR1aEjBkAa?ticker=
day2: - dv_options.j;jsessionid=avOgpHhrDlIa?ticker=
Each Day for 20+ tickers
Currently I go get the ‘hash’ manually from the main URL copy to a cell that generates the link in the cell beside where I need to paste the External Data and copy, move to target cell, Insert>Link to External Data> and paste that days URL in and complete the wizard.
I would like to open the sheet [NO to update links] update the ‘hash’ cell, then Edit>Links>select all Update.
Or to do it with a macro [when I tried it with ‘record macro’ it just added a remark for the section I really wanted to automate.
Any thoughts?