I am not sure if I understood well, but it seems that you are trying
to recover stocks end of the day quotes.
Is that it?
If you live in North America, why don't you simply use a WebQuery
(the MSM webquery works great), that will bring the requested tickers
directly into your workbook.
If you do not live in North America, you could probably create
another Webquery of your own.
If I understood you right, tell me and I could tell you more about
how to do that.

thanks for the reply, here is what i am trying to do in gist.

suppose i have 4 columns of data in A, B, C and D. the first row
contains headings as name, tradedate, expirydate and closeprice. the
first column contains (under name) security name. i have data like this
running upto 150 rows. now i would like to do is



a) extract few rows of data from the sheet into new sheet by referencing
to names in another notepad.

b) create another column named as symbol based on the values of
tradedate and expirydate and name columns and append to the data file.

c) delete the column expirydate.


i live in India, and the two prominent commodity exchanges here are
NCDEX and MCX. they publish End of Day data everyday and but we need to
do something additional so that is can be updated to metastock for
analysis. i am trying to create a macro that automates this process and
once done will be very helpful for many of the traders overhere.