|
|
#2
07-11-2016, 09:55 PM
|
|||
|
|||
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. 
|
| Tags |
| relational, worksheet relationships |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Relational results
|
tel703 | Excel | 2 | 05-19-2016 09:54 AM |
| VBA Worksheets in Excel | Iraj | Excel Programming | 1 | 05-08-2016 08:59 PM |
| How do I set default workSHEETs? | CanvasShoes | Excel | 1 | 08-03-2015 02:39 AM |
| Convert manual cross references in footnotes to other footnotes to automatic cross references | ghumdinger | Word VBA | 7 | 11-20-2014 11:47 PM |
| Help with worksheets on Word | eballi | Word | 4 | 11-18-2009 05:17 AM |
Windows 10 
Office 2016
Threaded Mode