Cross Reference From One Sheet to another in Excell

[Crystal Hayes]

I know that in word I can insert a cross reference and set it so that it will auto fill the same info where ever I have the cross reference set at throughout my whole document. I am trying to do the same thing in excel but throughout several sheets in the same workbook.

[#2 · Accepted solution]

Hi Crystal,

Did you try using Insert - Links - Insert Link and then using "Place in this document" option? It would work easier if cells you want to reference from other sheets have names defined.

See attached for this option dialog.