I want three columns in an excel file. (very large with tons of rows)
The column A has names of customers and
for column B I want to have the hyperlink to each customer website.
For column C I want their e-mail adress (mostly [email protected], so I won't mind any misfires when they have a different adress. I'll search that manually if there is no other way)
Example: If column A of row 1 was "Boeing". Then column B of row 1
is www.boeing.com
My clients normally don't have a separate 'contact' page, so we don't have to worry about that.
I know this is possible, because I saw an earlier post about this issue. Only there he had this working, but was asking for the google link instead of the homepage.
Someone else asked my question, but was sent away by an admin, after which he never posted the question again.
Since the list is over 35,000 rows it would be very time consuming to search one by one in google and copy and paste the homepage url and e-mail adress. Is there a automated way /via batch file writting that I can let one excel file convert alll the names in column A into homepage adresses in column B without having to do them one by one???
Any other method is also very welcome. I'm new to this whole automation thing
Thanks!
Bookmarks