Forum Discussion
Program a cell reference from another sheet
I need to be able to take the formula "=sheet2!c12" and be able to change the "C" in the formula many times in the worksheet so I don't have to change it manually across the rows. I want a cell that ...
=INDIRECT(ADDRESS(12,COLUMN(INDIRECT(A1&"1")),,,"sheet2"))In cell A1 enter the letter of the column e.g. C, D or E....