1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Filling the blank column B using a Google web scraping

Hi, so I want to find the name of the Treasury Manager in Column B. However, there are 1500 names and I have shown only 2

I want to use Google search to directly post the name itself. I have read that the =INDEX(IMPORTXML()) function would help but I have no idea how to use it

Any help would be gladly appreciated

An image for reference:

https://ibb.co/whdYxSmY

submitted by /u/Fair_Step_9600
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article