There are 20 cells that have functions like this:
A1 =index('sheet2'!$A$1:$B$3) C1 =index('sheet3'!$A$1:$B$3) E1 =index('sheet4'!$A$1:$B$3)
So in each function, only the sheet number changes, but the range remains.
My problem is:
I want to change the range (e.g. from
C1:D3) of all functions, but don't want to change them one by one, is there any convenient ways to modify all of them at once?