Automatic adjustment when copying of column reference within INDIRECT function
An as yet unanswered question on Web Applications, INDIRECT cell reference - Can't copy cell as reference cell pattern remains same, from @Daniel Klose is:
I have an Overview Sheet where I want to display a sum of values from another sheet. I'm using the indirect function to grab the sheet name from a cell in the overview sheet. The formula looks like this and sits in Cell C16:
When I now copy the cell to the next column (D16) the reference should adjust like so:
But it doesnt, it just remains as is. How do I get the formula to adjust the text part in the INDIRECT function as well?
Is there a way to achieve the end results sought with a single formula?