+ Reply to Thread
Results 1 to 4 of 4

Delete & Merge Columns,Delete Rows with filter, etc

  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

  2. #2
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

    Re: Delete & Merge Columns,Delete Rows with filter, etc

    I suggest CREATE(or record) a macro following the various steps. and look at this macro and you can modify the macro to generalize.

  3. #3
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Delete & Merge Columns,Delete Rows with filter, etc

    Edit the path for your files, then this does what you want, should give you a basis for developing your own final macro:
    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

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

    Re: Delete & Merge Columns,Delete Rows with filter, etc

    Thank you JBeaucaire for the code,

+ Reply to Thread

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