Excel vbscript

Help
1

Hi please can any one tell from below excel screen sheet

From column 1-oct-17 when it reaches jth row than i needs to start from (C2) column three 2-oct-17

How to do this in vbscript

Exl
Exl1366×768 145 KB

2

Dim xlApp
Dim xlBook
Dim xlSheet
Set xlApp = CreateObject(“Excel.Application”)
xlApp.visible = true
Set xlBook = xlApp.Workbooks.open(“D:\Macro\BirthDay.xls”)
Set xlSheet = xlBook.Worksheets(“Sheet1”)
MsgBox xlSheet.Cells(1, A1).Value

Please refer this link: vbscript - Reading all rows of a specific column in excel with VB Script - Stack Overflow

if you iterate and do increment and change column and row values then you can achieve your desired cell values.