data
A
1-41
2-19
3-12
4-80
5-36
numbers continue to be added in the column above.
If I add another number, I want it to be placed in another column i.e. k50.
when i entered 12 in column A3 it also placed it in k50.
when i entered 80 in A4 it replaced the 12 in k50 with 80, etc.
how can i do this?