MACRO HELP,Every 15 mins

[Techtrend]

HI

from Main Oi sheet the Data gets Copied to Sheet 2 when we click on Get Button,

Instead

I need a Macro where the data Gets copied every 15 mins from the time we Run Macros in the similar format

Pl help me on the same

 

[Techtrend]

Any help on this project

 

[Logit]

.

Dim TimeToRun

Sub auto_open()
    Call ScheduleCopyPriceOver
End Sub

Sub ScheduleCopyPriceOver()
    TimeToRun = Now + TimeValue("00:15:00")
    Application.OnTime TimeToRun, "CopyPriceOver"
End Sub

Sub CopyPriceOver()
    Calculate
    PasteSpecial_DATA_10     '<--- this calls your macro
    Call ScheduleCopyPriceOver
End Sub

Sub auto_close()
    On Error Resume Next
    Application.OnTime TimeToRun, "CopyPriceOver", , False
End Sub