Insert a link to another sheet based on pivot table results

[oldmanwilly]

Hi

Bit of a tricky one. I have two sheets, a data sheet and a summary sheet. On the data sheet is name, score, and code
ofn the summary sheet is the name and score and a column where I want a link to be inserted.

example:

sheet 1:
name score code
bLACK 5 1A
RED 4 2A
BLUE 5 3A

SUMMARY
5'S
NAME SCORE LINK
BLACK 5 NSERT LINK TO SHEET 1 ROW BLACK
BLUE 5 iNSERT LINK TO SHEET 1 ROW BLUE

4'S
NAME SCORE LINK
RED 4 NSERT LINK TO SHEET 1 ROW RED

The summary sheet is a few pivot tables filtering by scores. Is there a way to look up the code and insert a hyperlink using VBA or non VBA?

Thanks

This is a really important piece of work and if its not possible please let me know

Thanks

 

[oldmanwilly]

I TRIED THIS:

=INDIRECT("'Data Input Template'!"&"$B$"&MATCH('SUMMARY 2 (2)'!A9&'SUMMARY 2 (2)'!B9,'Data Input Template'!$S$1:$S$682,0))&"'!$B$"&MATCH('SUMMARY 2 (2)'!A9&'SUMMARY 2 (2)'!B9,'Data Input Template'!$S$1:$S$682,0)

but the link doesn't work, the indirect formula brings back 'data input template'!$B$3

Anyone able to solve this?

 

[oldmanwilly]

Morning

Has Anyone tried to solve this?

 

[oldmanwilly]

Might be a simple solution but I need help if possible

 

[oldmanwilly]

hello?

 

[oldmanwilly]

I'm so alone

 

[oldmanwilly]

Hi

No one on the website helped so I found the solution myself, which took a long time. However if anyone is interested in this you have to use a # in your hyperlink formula to reference sheets within the same spreadsheet. My formula eventually looked like this and worked perfectly:

=IF(ISBLANK(B9),"",HYPERLINK("#"&ADDRESS(MATCH(B9&C9,'Data Input Template'!$S:$S,0),4,,,"Data Input Template"),"Click Me"))

which is basically saying if B9 is not blank then put a hyperlink that links to my sheet(data input template) and the row it selects will depend on the the match formula. the 4 is the column I want selected

Thanks Oldmanwilly