EXCEL VBA data scraping from several e-shops hyperlinks placed in sheets in column H and updating product name in B column and price in D
Budget: €30 – €250 EUR
We have an excel file with a few (12 now) excel sheets. In each of the sheets is a table with different hyperlinks to different e-shops (7 e-shops I will share the e-shop later if needed) and different products within the e-shops - always in column „H“. The aim is to create a VBA macro to import information - product name and price from the website links which are on the first, second, third ... to the last row of the “H” column and update the „B“ column (product name) and „D“ (product price) column, respectively. We would like to add information about when it was updated to column „I“ in the format of date and time.
We need to create a macro to do this, we don’t need to do it for all the shops one example is sufficient as proof that this works. And just describing the idea of conditioning the macro for adding other shops there and how to loop it so other shops will work as well.
We would like to see what the finished product looks like, just part of the macro is sufficient (not the whole macro) so we see this is clean code with descriptions and a video if it is working prior to full payment. We prefer to pay after finishing since any milestone will not give us anything, but we are ready to discuss. Thank you for your offers.
We need to create a macro to do this, we don’t need to do it for all the shops one example is sufficient as proof that this works. And just describing the idea of conditioning the macro for adding other shops there and how to loop it so other shops will work as well.
We would like to see what the finished product looks like, just part of the macro is sufficient (not the whole macro) so we see this is clean code with descriptions and a video if it is working prior to full payment. We prefer to pay after finishing since any milestone will not give us anything, but we are ready to discuss. Thank you for your offers.