Thread: How do you reference another worksheet without using its name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default 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


Reply With QuoteReply With Quote