Edit NSE Bhavcopy with a single click

#1
Hi All,

I have been editing the NSE Bhavcopy (for Capital Market segment) with a single click.

Here's the Excel Macro:

-----------------------------------------------------------------------
Sub EditBhavCopy()
'
' EditBhavCopy Macro
'
' Keyboard Shortcut: Ctrl+Shift+Y
'
Selection.AutoFilter
Selection.AutoFilter Field:=2, Criteria1:="<>BE", Operator:=xlAnd, _
Criteria2:="<>EQ"
Range("A150:A1599").Select
Selection.EntireRow.Delete
Range("A1445").Select
Selection.AutoFilter Field:=2
Selection.AutoFilter
Columns("G:H").Select
Selection.Delete Shift:=xlToLeft
Columns("H:H").Select
Selection.Delete Shift:=xlToLeft
Selection.Cut
Columns("B:B").Select
ActiveSheet.Paste
Range("A1").Select
ActiveCell.FormulaR1C1 = "TICKER"
Range("B1").Select
ActiveCell.FormulaR1C1 = "DATE"
Range("G1").Select
ActiveCell.FormulaR1C1 = "VOLUME"
Range("A1").Select
End Sub
------------------------------------------------------------------------
A macro automates editing by repeating the series of actions performed.

Additional help is available from Microsoft Excel or other spreadsheet program.
 

Similar threads