1

Topic: Change of coordinates at an array of cells

Help please with the code for such problem:
In the enclosed example there is a table on the first sheet with various values. On the second sheet there are direct references on cells of the first sheet. It would be desirable to change all links to the second sheet at once, i.e. in these links to change to certain value row number, for example on +2 or-1, etc. Well for example to make on the second sheet the button which causes InputBox, in it to enter for example "+3" or "-4", etc. and after that in all array of cells of the second sheet the coordinate of lines changes (for cell references of the first sheet), increased or decreased for this number (for example, was =1! C5, =1! C6, =1! D8, =1! D9, we do "+2", we receive =1! C7, =1! C8, =1! D10, =1! D11).

2

Re: Change of coordinates at an array of cells

Anmost;
Use the INDEX or , offset enter into a cell. And VBA it is not necessary.

3

Re: Change of coordinates at an array of cells

It turns out so with the link it is necessary to change each cell, and it is supposed that them some hundreds at least will be. Therefore it would be desirable all at once it was possible to drift on coordinate of a line, instead of in each function to register.

4

Re: Change of coordinates at an array of cells

And you formulas =1! C5, =1! C6 etc. in everyone separately register?
Enter in 4

 = (List1! C4; $A$1;) 

Also expand as usual. Then enter +2 or-1 in 1.

5

Re: Change of coordinates at an array of cells

Anmost,