Auto Copy and Paste data from one sheet to another Every minute

[Nishant S]

Hi,

Please refer to the file attached. Now the file is linked to my trading software and hence the values change every second. What I need is that the values in column B and C from Sheet1 be automatically copied and pasted in Sheet2 every minute. And this should happen from 9:15am to 3:30pm every weekday.

For example, At 9:15am values from Sheet1 (B2:C113) should be copied to Sheet2 (B2:C113). Then at 9:16 values from Sheet1 (B2:C113) be copied to Sheet2 (D2:E113),Then at 9:17 values from Sheet1 (B2:C113) be copied to Sheet2 (F2:G113) and so on. This should continue till 3:30 every minute.

Please help me formulate a VBA code for this.

Thank You!!!


▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

​

 

[vletm]

Nishant S
A sample-file for You. I cannot test all without data connection.

There is a [ RUN ]-button in Sheet2 - just right side of 'Scrip Name'-text.
Press it and .... wait until 3:30PM ...
or if You press later than that time then no need to wait so long time.