View Single Post
 
Old 08-08-2020, 09:28 AM
hiwire03 hiwire03 is offline Windows 7 32bit Office 2013
Novice
 
Join Date: Dec 2014
Posts: 17
hiwire03 is on a distinguished road
Default Formula for Cross Referencing Numbered List

I have a table with auto numbered rows.

Requirement.
(a) A Formula in the last column that must reference to a selected auto numbered row in the first column. Later, in case a row or column is inserted, the reference must change automatically to match the new value i.e. relative referencing.

(b) Optionally, if the reference is clicked on, it must jump to the particular target row referenced.

Regards
Attached Images
File Type: jpg Query Word Referencing.JPG (76.6 KB, 15 views)
Attached Files
File Type: docx Query Word Referencing.docx (15.0 KB, 5 views)
Reply With Quote