Hi, I am a basic user of excel and dont have advanced expertise in it.
If you could kindly give me some direction, I would be very grateful
to you. Thank you!

I have an excel sheet with about 200 stock tickers in 1st column - for
example, ALTH, CXM, DNDN, ZIOP, and so on.

For each stock ticker, say ALTH, I need to -

(a) I need to go the website:
http://www.nasdaq.com/aspxcontent/Ex...&mkttype=p re
and get the following values located in a table on this webpage -
Premarket Last, Premarket Volume, Premarket High, and Premarket Low. I
need to put them on columns 2,3,4 and 5.

(b) I then need to go to the website:
http://www.nasdaq.com/aspxcontent/Ex...kttype=a fter
and get the following values located in a table on this webpage -
Afterhours Last, Afterhours Volume, Afterhours High, and Afterhours
Low. I then need to put them in columns 6,7,8,and 9.

I need to do this for all tickers located in 1st column, and populate
columns 2 to 9 for these tickers.

Please advise easiest way to do this. Thanks again for your guidance.