cpupartsplz
New Member
- Joined
- Oct 18, 2006
- Messages
- 14
Hello,
I searched the forum for a similar problem and am very close to what I need, but not exactly there yet...
My spreadsheets are titled: "0", "1", "2", "3"...
I enter a value in K1 in "0".
I would like K1 in "1" to be (=0!K1 + 1)
I would like K1 in "2" to be (=1!K1 + 1)
etc...
There was a similar post on Yahoo! Answers and somebody suggested...
=INDIRECT("'Sheet "& VALUE(RIGHT( MID(CELL("filename"), SEARCH("]", CELL("filename"))+1,256), 2)) -1 &"'!A1")
Which I modified to...
=INDIRECT("'"& VALUE(RIGHT( MID(CELL("filename"), SEARCH("]", CELL("filename"))+1,256), 2)) +1 &"'!K1")
This almost works, but is off by 1...
When I change the "+1" at the end to "+0" or "-0" or take it out completely, it returns an error.
When I change the "+1" to "-1" it returns the original value in 0!K1.
Any ideas to off-set it just 1?
Thanks!
I searched the forum for a similar problem and am very close to what I need, but not exactly there yet...
My spreadsheets are titled: "0", "1", "2", "3"...
I enter a value in K1 in "0".
I would like K1 in "1" to be (=0!K1 + 1)
I would like K1 in "2" to be (=1!K1 + 1)
etc...
There was a similar post on Yahoo! Answers and somebody suggested...
=INDIRECT("'Sheet "& VALUE(RIGHT( MID(CELL("filename"), SEARCH("]", CELL("filename"))+1,256), 2)) -1 &"'!A1")
Which I modified to...
=INDIRECT("'"& VALUE(RIGHT( MID(CELL("filename"), SEARCH("]", CELL("filename"))+1,256), 2)) +1 &"'!K1")
This almost works, but is off by 1...
When I change the "+1" at the end to "+0" or "-0" or take it out completely, it returns an error.
When I change the "+1" to "-1" it returns the original value in 0!K1.
Any ideas to off-set it just 1?
Thanks!