Relative worksheet referencing
 

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.

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.