Delete & Merge Columns,Delete Rows with filter, etc
 

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

Delete & Merge Columns,Delete Rows with filter, etc
 

On Jul 15, 7:48*am, traderindia
wrote:
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

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