Thread: [Solved] relational references between worksheets
View Single Post
 
Old 07-11-2016, 09:55 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
You can use the very old XL 4 macro functions in Defined Names.

Open Name Manager and press New. In the New name dialog write PrevShtValue in the Name field. In the Refers to field write the following:

=INDIRECT(INDEX(GET.WORKBOOK(1),GET.DOCUMENT(87)-1)&"!RC",0)

If you now enter =PrevShtValue in Sheet2!A1 it will return the value in Sheet1!A1

Alternatively you will have to use VBA.
Reply With Quote