Autofill list from Internet

Closed
eskagsms Posts 24 Registration date Wednesday February 9, 2011 Status Member Last seen May 30, 2012 - May 29, 2012 at 07:27 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 7, 2012 at 10:22 AM
Hello,

I have a list of over 3000 company names in India. I need to check for each of them to see if they have their own website or not.

I am doing this by manually pasting each entry (company name) in Google and checking if there is any result of the company website such as www.companyname.com

Is there any way I can automate this?

Kindly advise.

Regards,

EskagSMS


1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jun 7, 2012 at 10:22 AM
Hi EskagSMS,

Wow, that is a huge task.

You could use VBA to create hyperlinks depending on the data in the cell.
It might also be a possibility to open the hyperlinks in batches of 10, or something like that, to cut down on the mouse clicks.

But checking out 3000 websites is still a huge task.

Let me know if you need any assistance.

Best regards,
Trowa
0