Sensex vs Nifty

Ever wondered why Sensex is around 25,000, whereas Nifty is only around 8,000. 

The table below provides a comparison between the two. See if you can spot the answer.

                

Features	Sensex	Nifty
Base Year	1978-79	1994-1995
Base Value	100	1000
Constituents	30	50
Calculation Method	Free-Float Capitalization (01-Sep-2003)	Free-Float Capitalization (26-June-2009)
Location	Mumbai	Delhi
Authority	Bombay Stock Exchange (BSE)	National Stock Exchange (NSE)
Base Capital	N/A	2.06 Trillion Rs.
Start Date	01-01-1986	03-11-1995

The trick is in the base year, as more time elapsed for Sensex, the index has multiplied more times even though the base is smaller. 

Excel copy from closed file with different column mapping

Private Sub CommandButton1_Click()

Dim wb1 As Workbook
Dim ws1 As Worksheet

Dim wbCopy As Worksheet

Set wbCopy = ActiveSheet

Pathname = ActiveWorkbook.Path & "\Files\"
Filename = Dir(Pathname & "*.xlsm")
Set wb1 = Workbooks.Open(Pathname & Filename)


With wb1.Sheets(1)
 .Range("B4:H4").Select
.Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
End With

wbCopy.Activate
    Range("B4").Select
    ActiveSheet.Paste
    Range("I4").Select
wb1.Activate
With wb1.Sheets(1)
    .Range("K4").Select
    .Range(Selection, Selection.End(xlDown)).Select
    Selection.Copy
End With
wbCopy.Activate
    Range("I4").Select
    ActiveSheet.Paste
wb1.Close



End Sub