I have been trying to figure this out and been reading for a couple days without success. I am not a programmer and have no programming background so hopefully someone on here with the knowledge I lack would be willing to help me. I am trying to get the company name and website for from Yahoo finance into Excel for a lot of tickers. I want to put the stock tickers into say column A and have a macro or web query that pulls in the corresponding full name of the company for that ticker as well as the website for the company both of which are located under the Profile tab in Yahoo Finance. I have a program I had written a while back that pulls in a bunch of other data and I have tried to reverse engineer it but like I said I am a coding idiot so that didnt work. Does anyone know how I could achieve this? Also I am not even sure it is possible to pull in the website. Thanks