asked on

How to copy values from one sheet to another at specific time

Dear sir,

I have excel where data is auto updated for every 1min and i need to copy data from mainsheet to another sheet at specific time i.e at 10 am in morning and 11 am in morning and this has to be done daily in a week, can anyone help...thanks
OLH-nse50.xlsx

Roy Cox

This would only work if the workbook is open at those times.

ASKER CERTIFIED SOLUTION

Shums Faruk

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

vijay vj

ASKER

Thanks sir, tomo morning i have to test and post my result, i think it will work perfectly..

vijay vj

ASKER

Sir VBA starts updating at 10.00 am and keeps on going on, but i need only at 10.00 am value, is it possible to capture like that or some thing like between 9.30 to 10am value and 10am to 11 am value .. sir

Shums Faruk

Hi Vijay,

Add this code in Update_at_10am at the end above Application.ScreeenUpdating = True

Application.OnTime TimeValue("10:00:00"), "Update_at_10am", , False

Open in new window

Same way add below code in Update_at_11am at the end above Application.ScreenUpdating = True

Application.OnTime TimeValue("11:00:00"), "Update_at_11am", , False

Open in new window

vijay vj

ASKER

I will change time and check it now sir........

vijay vj

ASKER

VBA working perfectly sir

Shums Faruk

Thanks Vijay,

For your points and comments.