update two stocks in every 5min/15min

[csatoskar]

Hi



I have excel files which contains Test Pair File and Live data file i want to update from Live data sheet to Test pair files every 5min time frame for ICICI & AXIS, NBCC & IRB as well as 15 min time frame for CIPLA & AUROPHARMA , BPCL & HPCL and also FROM "D" TO "P" columns are with formula which also copy paste as rate refresh
I tried following VBA
Sub CopyValues()
Dim RowNo As Long
RowNo = Sheets(2).Cells(Rows.Count, 2).End(xlUp).Row + 1

Sheets(2).Cells(RowNo, 2) = Sheets(1).Cells(23, 2)

Sheets(2).Cells(RowNo, 3) = Sheets(1).Cells(24, 2)

Sheets(3).Cells(RowNo, 2) = Sheets(1).Cells(26, 2)

Sheets(3).Cells(RowNo, 3) = Sheets(1).Cells(27, 2)


Application.OnTime Now + TimeValue("00:60:00"), "CopyValues"


End Sub

Please suggest ASAP

Thanks