Delete & Merge Columns,Delete Rows with filter, etc

[traderindia]

Hello,

I dont have any knowledge of VBA or How to create macro, Im usin
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 forma
change it to 07/14/2009 (this format mm/dd/yyy

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

4. Column C (EXPIRY_DT) date format is 24-Sep-09 , "dd-Sep-09" chang
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,..

 

[Matthew Herbert]

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,

Start by recording a macro with the above mentioned steps. Also, I
think you may mean concatenate the columns and not merge the columns
(see the CONCATENATE help file for the function, or use the "&", e.g.
=A1&A2), but I could be wrong.

The macro recorder will do much of what you need. If you still have
trouble after that, post the code that you have and ask for help with
a specific aspect of the code.

Best,

Matthew Herbert