I want to make a link between two spreadsheets, like if I click on a code in a cell, it opens the spreadsheet which the code refers/links to. 
Can we do a link between two Google Docs spreadsheets?
google drive;google spreadsheets
You want to enter a link in a Google spreadsheet.The syntax of the command is: =hyperlink(url;Phrase)The key is that the Google spreadsheet you want to open has a URL. 