I need to extract information from one website. I have 19 excell files with 30,000 direct links to a website. Every file contains direct links to sources that need to be extracted. There are 11 columns with headers. 5 columns are filled with info.
The rest 6 need to be filled:
1. Colour (not always present)
2. Yield (not always present)
3. Models (always present)
4. Cartridge (not always present)
5. UPC (not always present)
6. Price (always present)
Also, if you open the links, you will see there the picture of the product (not present for all pictures though). The pictures need to be extracted as well. The pictures need to have a kind of reference per product. It can be either description or part number.