Thread
:
referring to previous sheet
View Single Post
#
2
Don Guillett
Posts: n/a
the simplest is
=sheet2!a3
--
Don Guillett
SalesAid Software
"Iolao" wrote in message
...
I have a list of several sheets, named with numbers (1,2,3,ecc.). I need
some kind of function that allows me to have the value of one cell equal
to that same cell in 1 to 3 sheets before. Example:
sheet5
A3= value of A3 in sheet2 (5-3)
How is that possible?
--
Iolao
------------------------------------------------------------------------
Iolao's Profile:
http://www.excelforum.com/member.php...o&userid=16654
View this thread:
http://www.excelforum.com/showthread...hreadid=320575
Reply With Quote