Hello,
I have one Excel sheet related to Stock market, which will refresh every 5min after market open. I need to record data every 5min in another sheet automatically. How can I do this?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Recording of live data
0
Answers
0
The same code that refreshes your data every 5 minutes can be expanded to do other things in your workbook.