Results 1 to 4 of 4

Delete & Merge Columns,Delete Rows with filter, etc

Threaded View

  1. #1
    Registered User
    Join Date
    07-15-2009
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2007
    Posts
    14

    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,...
    Last edited by traderindia; 07-17-2009 at 02:12 AM. Reason: Solved thanks JBeaucaire

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1