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.