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