rowkan.mondal
New Member
Hello there.
I have a url list example (https://www.whitepages.com.au/a-720010001R) where (https://www.whitepages.com.au/a-) remains constant and the code (720010001R) at the end changes.
Now i want a macros where i can check all the links and only the links which have data (refer to attachement 1) i want to download the data like (Name, Address, Phone number) in the columns (B,C,D). Where the links remain in column A. The links which do not have data (refer to attachment 2)the column (B,C,D) remains blank.
I will be attaching a excel file with 50 link for reference.
Note the urls which do not have data also shows 404 message when clicked in excel sheet.
Thanking in advance
I have a url list example (https://www.whitepages.com.au/a-720010001R) where (https://www.whitepages.com.au/a-) remains constant and the code (720010001R) at the end changes.
Now i want a macros where i can check all the links and only the links which have data (refer to attachement 1) i want to download the data like (Name, Address, Phone number) in the columns (B,C,D). Where the links remain in column A. The links which do not have data (refer to attachment 2)the column (B,C,D) remains blank.
I will be attaching a excel file with 50 link for reference.
Note the urls which do not have data also shows 404 message when clicked in excel sheet.
Thanking in advance
Attachments
Last edited: