Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to merge text and delete rows | Excel Programming | |||
Help with filter Range & delete rows | Excel Programming | |||
merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
Delete rows in filter view | Excel Worksheet Functions | |||
Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming |