Reference/link between sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1458600%22%20slang%3D%22en-US%22%3EReference%2Flink%20between%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1458600%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%20I%20am%20trying%20to%20solve%20an%20issue%20creating%20a%20reference%2Flink%20between%20the%20excel%20worksheets.%20I%20have%20multiple%20sheets%20with%20data%2C%20as%20I%20can%C2%B4t%20use%20the%20original%20I%20have%20created%20just%20a%20simple%20example%20which%20I%20have%20uploaded.%20The%20very%20first%20(and%20the%20main)%20sheet%20is%20just%20a%20list%20of%20experiments%20and%20what%20was%20used%20in%20the%20experiments%2C%20another%20sheet%20has%20values%20and%20results%20of%20each%20experiment%2C%20the%20last%20two%20(x%2Cy)%20have%20graphs.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20create%20a%20reference%2Flink%20between%20the%20first%20one%20and%20the%20others%20not%20with%20formula%2C%20but%20if%20I%20%C2%B4%C2%B4click%C2%B4%C2%B4%20on%20a%20cell%20with%20specific%20word%20i.e.%20water%2C%20ID%20of%20the%20experiment%20it%20would%20then%20take%20me%20to%20the%20other%20sheets%2C%20where%20this%20word%2FID%20etc%20was%20used.%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%26nbsp%3BI%20could%20not%20find%20the%20answers%20anywehere%20else.%20Would%20anyone%20be%20able%20to%20help%20please%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1458600%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1459984%22%20slang%3D%22en-US%22%3ERe%3A%20Reference%2Flink%20between%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1459984%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F663129%22%20target%3D%22_blank%22%3E%40AnnaCer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20not%20exactly%20what%20you%20were%20describing%2C%20but%20I've%20done%20it%20just%20to%20illustrate%20what%20could%20be%20done.%20This%20isn't%20as%20%22pretty%22%20as%20it%20could%20be%20made.%20For%20example%2C%20we%20could%20create%20the%20drop%20down%20lists%20so%20that%20any%20one%20word%20appeared%20only%20once%20under%20the%20%22Used%22%20item.%20We%20could%20also%20put%20all%20of%20that%20into%20a%20%22dashboard%22...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20idea%20is%20that%20rather%20than%20taking%20you%20TO%20the%20sheet%20where%20that%20data%20appears%2C%20it%20brings%20the%20data%20to%20YOU%20(to%20the%20dashboard).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1463144%22%20slang%3D%22en-US%22%3ERe%3A%20Reference%2Flink%20between%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1463144%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%2C%20it%20is%20good%20idea%20as%20well%3A-)%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi everyone, I am trying to solve an issue creating a reference/link between the excel worksheets. I have multiple sheets with data, as I can´t use the original I have created just a simple example which I have uploaded. The very first (and the main) sheet is just a list of experiments and what was used in the experiments, another sheet has values and results of each experiment, the last two (x,y) have graphs. 

I need to create a reference/link between the first one and the others not with formula, but if I ´´click´´ on a cell with specific word i.e. water, ID of the experiment it would then take me to the other sheets, where this word/ID etc was used.

Is this possible? I could not find the answers anywehere else. Would anyone be able to help please? 

Thank you  

2 Replies
Highlighted

@AnnaCer 

 

This is not exactly what you were describing, but I've done it just to illustrate what could be done. This isn't as "pretty" as it could be made. For example, we could create the drop down lists so that any one word appeared only once under the "Used" item. We could also put all of that into a "dashboard"...

 

The idea is that rather than taking you TO the sheet where that data appears, it brings the data to YOU (to the dashboard).

Highlighted

@mathetes 

 

Thank you very much, it is good idea as well:-)