Hi,

first of all i want to say that i am a complete noob with excel (especially VBA - never programmed in it). So my goal here is to create a dynamic a web query with a dynamic URL. This url is coinmarketcap[dot]com/currencies/iota/historical-data/ i and want to put a parameter in this link: coinmarketcap[dot]com/currencies/ parameter_name_here /historical-data/, so that the URL will change whenever i change the cell value and with it, the parameter and the query contents. I know how to put the parameter in the link, but i don't know how to set up a dynamic parameter. My question is, how do i link a cell with the parameter? From what i've gathered, this is only possible in VBA.. Here's a screenshot of what i'm trying to achieve: imgur[dot]com/a/0LJgDD0
Sorry i'm not able to post full link because i haven't posted a few times before.