Hi all,
I have a sheet which uses a large number of basic references (eg C1='Sheet2'!B1) etc
I want to be able to assign a hyperlink to a cell on the base data page, and have each cell that references this base data cell pick up the same hyperlink, so thjat not only does it equal the value, but has the link as well.
I have attached a basic example workbook.
The yellow cell in D5 is my base data. In cells L5 and O13 i have simply entered " =D5 " so that whatever data is entered into D5 carries through.
How do i also get the Hyperlink to carry across to these other cells?
To add context:
the sheet is for a sporting tournament where some teams have specific sponsors, and i want to be able to link to that sponsors website direct from the team name.
The team may follow a number of different paths through the tournament draw, which is determined by wins and losses. The sheet is already set up to calculate where they go, and will automatically fill in their team name. All i want to do is be able to have the same hyperlink go wherever that team name goes.
Bookmarks