Create a link from WB2 Column A to WB1 column I @Dnorman1950

[Dnorman1950]

I am relatively new to the many functions/menu options in excel.  I need assist. There is a current link already in column I. It is Clinical Screenshots'!A37.  I need to create the same link in row 71 on WB1 but I must link Clinical Screenshots'!A66.  What is the best method.

[#2]

@Dnorman1950 

By "link", do you mean that the cell must show the same value as the cell on the other sheet?

If so, enter the formula ='Clinical Screenshots'!A66 in I71. Note the = at the beginning (as for each formula) and the single quotes ' around the sheet name; they are required because the sheet name contains a space.

Or do you mean a clickable hyperlink to the cell on the other sheet? If so, select I71, then click Link on the Insert tab of the ribbon.

Select 'Place in This Document' in the navigation pane on the left.

Type A66 in the 'Type the cell reference' box, and select Clinical Screenshots under Cell References in the box below that.

Click OK.

[#3]

Thank you Hans. This information was a great help! Have a good day!