Can someone please help me fix this code I want the macro to start at 7am and run every 15

[nareenrv]

Hi All,

I am new to VBA I have built a macro to capture data from one sheet to another.

Can someone please help me fix this code I want the macro to start at 7am and run every 15 min after that till 6pm and then close the work book.

Really appreciate any help thank you

The code that I have is

Sub Macro2()

Dim BlankRow As Long

Sheets("DATA").Select
Range("E2:E5").Select
Selection.Copy

Sheets("EWFM").Select
BlankRow = Range("E65536").End(xlUp).Row + 1
Cells(BlankRow, 5).Select
ActiveSheet.PasteSpecial xlPasteValuesAndNumberFormats

Application.OnTime Now + TimeValue("00:15:00"), "Macro2"


End Sub

[AlphaFrog]

Try this.

Please Login or Register  to view this content.

Run Timed_Copy_Start to start the timer. If it's started before 7 AM, the first copy will be at 7 AM. If it's started after 7 AM. It will copy immediately and then every 15 minutes after.

Run Timed_Copy_Quit if you ever want to stop the OnTime events manually. If you didn't do this and just closed the workbook but left Excel open, the workbook would reopen and run the OnTime event.

[nareenrv]

Thank you for that I will give it a go and let know how it goes, Really appericate your help.

[nareenrv]

It seems to be working but its coping the formula from the main cell, i need it to copy just the values ( just the numbers), i have also noticed that it sometime it copies the data 3-4 time in a 15 min run, is this issue because of the my excel.

Quick question Do i need to leave Excel Open for this to run on time
Thank you and really appreciate your help

[AlphaFrog]

It seems to be working but its coping the formula from the main cell, i need it to copy just the values ( just the numbers),

Change this...

Please Login or Register  to view this content.

To this...

Please Login or Register  to view this content.

i have also noticed that it sometime it copies the data 3-4 time in a 15 min run, is this issue because of the my excel.

I'm not sure why that would happen.

Quick question Do i need to leave Excel Open for this to run on time

Yes

Thank you and really appreciate your help

You're welcome.