adressing rows in function

[proximate3]

Hello,
I got problem with adressing number of row in function.

for expl. I got ='ANOTHERLIST' !A267 in multiple instaces on same page (B267, C267, D267....) is there i way how to make when i change number in one row to another number ( ='ANOTHERLIST' !A267 -> ='ANOTHERLIST' !A215) to change with it all lines at once.

Thanks for answers.

[AliGW]

Welcome to the forum.

You could use Find & Replace for this.