I'm not even sure how to word this request.
Some of the experts that have assisted me in the past are aware that I'm embarking on a new career trading stocks and shares.
In this request whenever a change has occured in any of the cells in row 3 that change will placed in the row 4 below. When another change occurs in any of the cells in row 3 then that will replace the current values in row 4 and the those values in row 4 will now be placed in row 5 and so on.....
This is probably the most challenging request I've ever asked.
So lets say in the current value in cell b3 is 50 it then changes to 150, the old value of 50 will now be pushed into cell b4. Now, cell b3 has now changed from 150 to 275, the value of 150 will now be pushed into b4 and the old value in b4(50) will be pushed into b5. So each time the value changes in B3 everything will be pushed down one and so on ...
I attached the spreadsheet.
I really hope you guys/grls can help me out.