Refer current cell in other sheet

jokr1

New Member
Joined
Jan 10, 2016
Messages
43
I have two sheets, "SheetA" and "SheetB"

Is it possible in SheetB to refer to the same cell in SheetA with the same code no matter which cell in SheetB you use the code?

What I mean is in cell C4 SheetB not refer to C4 in SheetA by using
=SheetA!C4
but rather by using something like:
=SheetA!(same cell as where the code is in SheetB)
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,513
Office Version
365
Platform
Windows
Is it possible in SheetB to refer to the same cell in SheetA with the same code no matter which cell in SheetB you use the code?
Not really clear what you mean by this.
Can you provide an ACTUAL example, telling us exactly what is in the cell that you are trying to match up?
And what are you trying to do with this information once you identify the cell?
 

jokr1

New Member
Joined
Jan 10, 2016
Messages
43
I wonder if it is possible to use something like

ADDRESS(ROW(),COLUMN())

to address the same cell in another sheet?
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,513
Office Version
365
Platform
Windows
Try this:
Code:
=INDIRECT("SheetB!" & ADDRESS(ROW(),COLUMN()))
 

jokr1

New Member
Joined
Jan 10, 2016
Messages
43
Thank you, works perfectly!
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,513
Office Version
365
Platform
Windows
You are welcome.
Glad I was able to help!
:)
 

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
9,017
Or a non-volatile version:

=INDEX(SheetB!$1:$1048576,ROW(),COLUMN())
 

Forum statistics

Threads
1,082,601
Messages
5,366,571
Members
400,902
Latest member
fathima

Some videos you may like

This Week's Hot Topics

Top