Hi all
Just had a quick question. In my excel I have a live feed from a stock exchange. I want to record the value of the stock exchange every 15minutes. I have searched on here and I am currently using a macro that records every time the live feed changes. Only problem, is that within a couple of minutes I have about 180 cells with data. I just need data points for say, every 15minutes. Does anyone have any suggestions?
Currently I am just right clicking on the excel tab and going view code and entering my code there.
I'm new to macro's so would appreciate it if you could walk me through with baby steps.
Thank you very much for your time!
cheers, jono
Bookmarks