Thread: Relative worksheet referencing
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Relative worksheet referencing
Use the INDIRECT() function or a UDF. See Excel Help
--
Gary''s Student - gsnu200793


"Niju David" wrote:

In relative and absolute referencing we have either the row changing or the
column changing and the worksheet remains the same. How can we create a
relative reference whereby the row and column remains the same but the
worksheet changes.
Reply With QuoteReply With Quote