I am trying to pull data from the following base url:
However, the underlying url in the script is like this:
Here, the variable parameters are ReportID and ControlID
What I want is that I should be able to enter these two parameters in two different cells and then they should be automatically pulled in the above url as I change them and the query should pull the data into my worksheet.
How can this be made possible pls guide me I am new to VBA and macros with only basic understanding.