Hi,
I have a tab titled Compendium. In cells C2:C350 I have a list of words.
I have a tab titled Dates. In cells A2:A350 I have linked the cells to the Compendium tab copying this formula: =Compendium!C2 down to row 350 in the column.
I want to create a hyperlink from cell C2 to A2 and from A2 to C2 and do the same all the way down to row 350. (I call them cross reference links)
It's easy enough to do it manually from one to the other and back (right clicking on the cell/Insert Hyperlink/Place in The Document, selecting the tab and typing the cell to link to) but copy and paste does not work all the way down a column as you can with a formula.
Your advise is valuable.
Thanks,
Amal
I have a tab titled Compendium. In cells C2:C350 I have a list of words.
I have a tab titled Dates. In cells A2:A350 I have linked the cells to the Compendium tab copying this formula: =Compendium!C2 down to row 350 in the column.
I want to create a hyperlink from cell C2 to A2 and from A2 to C2 and do the same all the way down to row 350. (I call them cross reference links)
It's easy enough to do it manually from one to the other and back (right clicking on the cell/Insert Hyperlink/Place in The Document, selecting the tab and typing the cell to link to) but copy and paste does not work all the way down a column as you can with a formula.
Your advise is valuable.
Thanks,
Amal