I need a VBA app (macro) to read the SKU in the ProdInfo sheet and for each value, go to the manufacturer's website, find the product listing on their site and extract the product data. The data will include the following:
Weight (if available)
Size (if available)
Category or subcategory (if available)
To keep it simple, the drop down box needs to be populated with the Manufacturer's name to be chosen at run time. The data in the ProdInfo sheet will always have the SKU in the first column and there will always be a title in the first row.
The program will then loop through the values, open the webpage, search for the SKU and then extract the data into a new worksheet. All superfluous html will need to be removed saving only <p></p> for paragraphs and <ul></ul> for lists. No other formatting is to be saved.
I have updated the excel file with other examples of the data to be gathered. The SKUs will be cleaned by me before running executing the macro. Not every site may be able to be scraped. Review the URLs and determine which sites can be scraped and which cannot.
22 freelancers are bidding on average $194 for this job
Hello, I am working with Excel for a long time and I can create complex formulas and macros. I can complete the web scraper for you. If you are interested please open a chat with me. Kind regards, Sorin