Hello Narnimar:
I think the INDIRECT function is what you might be looking for. Paste the formula in the desired location and type the sheet numbers in column K, then drag the formula down as far as needed.
Code:
=INDIRECT("Sheet"&$K1&"!$A$1")
Matt
Quote:
Originally Posted by Narnimar
I am looking for method of linking the cells of various cells from various
sheets I formatted identically.
A1 B1 C1 D1
E1 F1
='sheet2'!$A$1 ='sheet2'!$B$1 ='sheet2'!$C$1 =sheet2'!$D$1
='sheet2'!$E$1 ='sheet2'!$F$1
='sheet3'!$A$1 ='sheet3'!$B$1 ='sheet3'!$C$1 ='sheet3'!$E$1
='sheet3'!$E$1 ='sheet3'!$F$1
and so on... if I drag the cell A1 which is ='sheet2'!$A$1 to A2 then the
cell A2 should give the result ='sheet3'!$A$1
I tried by dragging down the linked cells of A1 but it does not link to
sheet2 and so on . How to get that done without macro?
|