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).