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!
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!