NEED EXCEL VBA HELP FOR SMALL AUTOMATION. IS ANYONE CAN HELP..

[AJ_121]

Dear I'm a stock market guy and need a help as i'm not that much software engineer, only little knowledge i have.

I have done some steps to automate my data which is below:

Step1: I am using a excel sheet which has automated data pulling function in Sheet 1 and i get the data and some amount of data from sheet 1 copied onto Sheet 2 on Cell B3:L13 via Vlookup function which i have set and this data change after 2-3 minute automatically.

Step2: And in sheet 2 i run a Macro to copy the data of Cell B3:L13 into Cell B33:L44 and i run the macro manually every 2-3 minutes when my data of Cell B3:L13 update automatically.

Step3 I run the another macros for copying the updated data of B3:L13 into Cell B48:L58

and i simply run a macro every 2-3 minutes so i am verry irritating because i have to do it manually. So i need to do it automatically like when i open the file and i start One Macro which automatically copy the sheet B3:L13 data into new cells after 2-3 minutes OR a Macro should be which Call my Another Macro Automatically after 2-3 minutes which macro i have already made.

I have attached a image to understand the logic easily

I have tried a lot to automate it or call the macros after every 2-3 minutes, but Failed...


Kindly Help..

Any help is greatly appreciated!

 

[GlennUK]

Have you looked at the OnTime method? The logic being that at the end of your macro you set another run of itself in a couple of minutes.

Application.OnTime method (Excel)

Office VBA reference topic

docs.microsoft.com

 

[AJ_121]

Have you looked at the OnTime method? The logic being that at the end of your macro you set another run of itself in a couple of minutes.

Application.OnTime method (Excel)

Office VBA reference topic

docs.microsoft.com

Hi Glenn,
Thanks a lot for your Link..
Actually i did this earlier but failed many times due to logic behind it which i couldn't understand and spoiled my many nights..
But which link you have mentioned, i got the logic and did my work.

Again Thank you from the bottom of my heart Glenn and wish you best of luck.