I was wondering if there was a way to create a macro that will do a web search of a company name(column A) and insert the hyperlink in column D. I have a huge list of names and I am trying to see if there is an easier way to add them.
What I currently have;
(Column A) (B) (C) (D)
A & S Pharmaceutical Corp. Bridgeport CT +1-203-368-2538 Hyperlink
A & Z Pharmaceutical Inc. Deer Park NY +1-631-952-3800
Aaron Industries, Inc. Clinton SC 864-833-0178
Abbott Laboratories Abbott Park IL 847-937-6100
Is this even possible or another easier way to do this? This would save me a ton of time if there is a macro.
What I currently have;
(Column A) (B) (C) (D)
A & S Pharmaceutical Corp. Bridgeport CT +1-203-368-2538 Hyperlink
A & Z Pharmaceutical Inc. Deer Park NY +1-631-952-3800
Aaron Industries, Inc. Clinton SC 864-833-0178
Abbott Laboratories Abbott Park IL 847-937-6100
Is this even possible or another easier way to do this? This would save me a ton of time if there is a macro.
