I want to log download file in excel ?
Read by rows column A in file1 and choose item in web.
Step2 : If have file click download and write file2 in column G = “Y”
but if in web don’t have file —> write file2 in column G = “N”
Remark : some report in file1 have 2 No.
example : report BBV have No. P1 and P2.
If have file , write “Y” in rows P1 and P2.
Please guide me about it.