I have little to no programming knowledge or how to work with VBA.
I was wondering if there was a way to write a VBA code to extract data from my company website based on unique product ID's to an excel worksheet.
The first step is always to have a basic understanding of HTML. You will need to learn the basics such as <li> for list, <tag> for tag and <class> for class.
If you just need the information from time to time, you can consider browser plugins for web scraping.
You may also try options without VBA, such as Power Query, and Excel 365's FILTERXML() function. You can also use Google Sheets' ImportXML() function. https://support.geckoboard.com/hc/en-us/articles/207238327-Use-Google-Sheets-ImportXML-function-to-display-data-in-Geckoboard