Dynamic Web Search Results

[JustinT]

I've been assigned a project by my boss. Go on website X and lookup a part number in the search box, then take the results and paste them into a excel spread sheet. I know there is a way to do this in Excel 365. Can someone point me to a great guide to accomplish this? Save me the chore of copying and pasting 1608 lines.

Thank you

 

[Chihiro]

That really depends on site set up. There is no one size fits all steps/codes for scraping web data.

Have a read of...
https://www.excelforum.com/excel-ge...power-query-to-import-from-url-all-pages.html