I need to add Indirect to 5000 rows of formula. So, with the following
formula, how can I get it to fill with the correct cell references(T2 becomes
T3 and Z2 becomes Z3 and so on down the column)?
=SUM(INDIRECT("Allocate!T2")+INDIRECT("Allocate!Z2 "))