How do you reference another worksheet without using its name
 

The standard way to reference a cell on another worksheet within the same
file is Sheet2!A1. How can I create a reference that basically says A1 in
the next worksheet irregardless of its name (i.e., current worksheet + 1).

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200904/1

How do you reference another worksheet without using its name
 

Use =INDIRECT(A1&"!A2") where A1 = "<sheetname"
--
If this post helps click Yes
---------------
Jacob Skaria


"dallen917 via OfficeKB.com" wrote:

The standard way to reference a cell on another worksheet within the same
file is Sheet2!A1. How can I create a reference that basically says A1 in
the next worksheet irregardless of its name (i.e., current worksheet + 1).

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200904/1