Hi Everyone,
I need a help on the following query.
Query:
I have website names in column D2, and I need a macro to open this link and search for the page (either Events or Presentations) and copy the corresponding link and paste into my excel at Column C2.
For Example:
In D2, I have this link: http://www.samsung.com/us/aboutsamsung/ir/newsMain.do
and in C2, I need this link to be pasted,
http://www.samsung.com/us/aboutsamsung/ir/ireventpresentations/ircalendar/IR_IRCalendar.html
Hope, I made this clear and would appreciate all your valuable suggestions.
I need a help on the following query.
Query:
I have website names in column D2, and I need a macro to open this link and search for the page (either Events or Presentations) and copy the corresponding link and paste into my excel at Column C2.
For Example:
In D2, I have this link: http://www.samsung.com/us/aboutsamsung/ir/newsMain.do
and in C2, I need this link to be pasted,
http://www.samsung.com/us/aboutsamsung/ir/ireventpresentations/ircalendar/IR_IRCalendar.html
Hope, I made this clear and would appreciate all your valuable suggestions.