Hello,

I dont have any knowledge of VBA or How to create macro, Im using
Office 2007.
I need a macro,Please help me as much as you can,
Kindly download file from below link

http://nseindia.com/content/historic...UL2009bhav.csv

Please open the CSV file,

1. Remove J,K,N,A Columns,

2. In the last O (TIMESTAMP) column, the date is 14-Jul-09 format
change it to 07/14/2009 (this format mm/dd/yyy

3.Filter L column (VAL_INLAKH) Remove all rows from whole sheet which
has 0 value

4. Column C (EXPIRY_DT) date format is 24-Sep-09 , "dd-Sep-09" change
to "Sep" only

5.Merge Column B,C,D,E (SYMBOL. EXPIRY_DT .STRIKE_PR .OPTION_TYP
respectively )

eg
before MINIFTY 24-Sep-09 3400 PE
after MINIFTY-Sep-3400PE

Please anybody create a macro, It would be very helpful for me,

Thank you.. Im waiting for replies,...


--
traderindia
------------------------------------------------------------------------
traderindia's Profile: http://www.thecodecage.com/forumz/member.php?userid=517
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116192