Formula to sheet change
Is there a way To write an Offset formula that changes the sheet name when
indexed on a cell?
Ex: =OFFSET(A1!A2,A3,1)
Whe A1 = sheet name cell value the offset refers to, A2 = start cell, A3
= row to offset.
When I use "Sheet1!" in cell A1 it opens the File Not Found dialog.
--
George G
|