if your data is in column A

=INDEX(A:A,COUNTA(A:A),1)


"nima" wrote:

hi friends
please say me thet :
how i can create link from the last cell in one daynamic column (this
column is growing up) to another cell in another sheet?

in this case i want to have value of last cell of that column when my list
in that column is growiing and my last cell moving down.