Re: Shifting column # in a referencing formula
Quote from The Heggins;776031
I absolutely agree with you the INDEX/INDIRECT would work very nicely, but lets just say that management likes to see that the cells are directly linked when they are reviewing.
Management that imposes those kinds of restraints on its coders isn't competent to review worksheet formulas.
[ insert rant that reminds you of the Wobblies (IWW) ]
Perhaps management would be satisfied by the use of Names.
Instead of having ='xxxxxxxxx\[Book1.xlsx]Sheet1'!$A$1 in a cell and being altered by the user changing OtherSheet!Z1
Perhaps the cell would contain =myCell and the name myCell referring to an INDEX function.