I don't know if this is possible because i've been googling this for days and haven't had luck looking for what i want. I even tried recording a macro and it didn't record anything when i tried to do a manual web query.

What i want this VBA to do is; I will write a bunch of invoice numbers in column A (sheet1), starting with cell 1 to an indefinite number down the column because each day it varies between 20 to 200. I want the information to be pulled from website http://onescan.logistics.corp/

So for instance, I write the number 11406733 in A1 in excel, i want it to take the number, put it in the search box

7J70FkC.jpg

then i want it to click on the hyperlink titled "OH - House Bill Lading" which will make the PDF optional to save using I.E.

0bsWdVp.jpg

the search box input is in this first pic btw