Scraping 12 websites in single sheet
IT, Apps, & Programing
Development and Programming
VBA/Macro
Duration to complete job5days
My client objective was to get the prices of 52 item which are available on 12 different websites to be able to support on taking the decision while doing the supply order
I was able to create a VBA script which successfully scrape each of the 52 item on each website and collect the prices into one sheet ,also made a windows forms upon clicking on start which allows the client to pick which sites he needs to scrape.
This project helped my client reducing the manual work he used to do also the cost since he had to hire some one to get these data if needed but now he has all what he needs to get the data in the future
live scraping :
https://youtu.be/x9_785qJwoY less