Data Scrapping from Web

[norto88]

Hi Everyone,

I am currently extracting data from google scholar into excel.

However I encounter a problem every time I auto refresh the data names of authors disappear and reverts back to column 1.

Anyone know a way to fix this issue?

I have attached photos below.

 

[norto88]

Anyone has an answer let me know thanks.