Hi all,
First time poster, so excuse me if I've made a mistake anywhere.
I would like to pull house price data from imot.bg. The normal Excel web query doesn't work because the table is created dynamically (javascript). I would like to automate the process if possible because each table contains weekly data and I need to pull them for the last couple of years.
The closest I came to an answer was this thread. However, the suggested VBA code didn't work or more likely I don't understand it well enough to adapt it to my case.
Would appreciate it if someone has a suggestion.
I am running Excel 2013 on Windows 10.
To generate the table that I need follow the screens.



First time poster, so excuse me if I've made a mistake anywhere.
I would like to pull house price data from imot.bg. The normal Excel web query doesn't work because the table is created dynamically (javascript). I would like to automate the process if possible because each table contains weekly data and I need to pull them for the last couple of years.
The closest I came to an answer was this thread. However, the suggested VBA code didn't work or more likely I don't understand it well enough to adapt it to my case.
Would appreciate it if someone has a suggestion.
I am running Excel 2013 on Windows 10.
To generate the table that I need follow the screens.


