hello everyone, i am just learning vba and my ideas are way ahead of my vba programming capabilities. here is my new idea, something i hope is possible with vba:
i import live feed data into excel spreadsheet from my trading program, and it looks something like this "=TOS!msft" in each cell.
so if i have a few cells in the first row of such data, which changes maybe every second (sometimes more often)....is there a way for VBA to look for any changes (in any of the cells) and if it spots a change, it pushes the values before the change took place to the 2nd row, so the "freshest" data is on the first row. and once that changes again, it'll push that to the 2nd, and the 2nd row to the 3rd...and just do this all day long and make a little database.
i dont even know where to begin with something like this, so hopefully someone will be able to tell me if this is possible and if it is, how difficult of a project it would be.
thank you all!
Bookmarks