I work for a Stationery company and we constantly need to find cartridges for Printers with a Printer Supplied
I'm trying to get data from a website into Excel.
The Website is http://www.dynamicsupplies.com.au
the search URL is http://www.dynamicsupplies.com.au/search.php?Vendor2=Search+All+Manufacturers&q=%CODE%&Submit=Search
replacing %CODE% with a search string from Excel
I know a fair bit about Excel and VBA but i'm hopeless when it comes to HTML and the Code tags.
I've attached a before and after of what i would like
I have Chrome and (obviously) internet Explorer installed.
can anyone point me in the right direction?