Thread: How do you reference another worksheet without using its name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dallen917 via OfficeKB.com dallen917 via OfficeKB.com is offline
external usenet poster
  
Posts: 5
Default 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

Reply With QuoteReply With Quote