Its from a trading website.
It gives you the option to connect to excel where you can create your own stuff.
The feed I am interested in is the last traded price, the designated cell for this is M12.
When I click the cell the code contained there reads, ='trading website'!M12
If I put this code into a cell onto a blank sheet it replicates the same price as on sheet1.
Once the LTP changes from the website it changes the value in M12, I wanted to move value1 down one cell and display value2 above it instead of replacing it.
I was hoping to compile a long row of these changes if its possible