ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   cell links (https://www.excelbanter.com/excel-worksheet-functions/30008-cell-links.html)

nima

cell links
 
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.

JMB

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.



All times are GMT +1. The time now is 02:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com