How to Link Cells in Different Google Sheets

Here is the Formulat you need for How to Link Cells in Different Google Sheets:
=IMPORTRANGE("WORKSHEET ID","Sheet Name and Cell")

How to Google shows you how to link cells in different google sheets. This is how to link a cell to another cell in a different google sheet. You can link multiple workbooks with this. When you need to link 2 google sheets this is what you need to do.


If you liked this quick How to Google video, please Like and Subscribe for more videos.

As always please if you have questions, comments, suggestions, or an idea you would like to see please comment below or contact us

[loudaboutit]

I wish all YouTube videos were so straight forward and as helpful as this one. THANKS A MILL!!

[WonderTwinsActivate]

You are a life saver! I spent hours trying to get the formula right and none of the search results helped me but this explanation. Kudos to you!

[cyedwgp]

Found that i had to use the full link, but this worked. Thank you!

[ronedmonds]

Bless you! I have spent hours messing with this. THANK YOU!!

[mathewjoseph]

One more thing learned .. Big thanks
One humble suggestion .... while explaining the process .... In the formula ... please specify .. you need not mention the File name ( as it is already taken care in the long alpha numeric Google file link) ..so only mention the Sheet No or Sheet name )

[msaqib]

bRIEFLY EXPLAINED, GOT THE SOLUTION, THANK YOU

[mmanagement]

Hey how do I do this but within the same cell sheet?

[David-tgbg]

Concise, excellent explanation. Kudos!

[nhtp]

Is it possible to drag the linked cell downwards / horizontally so other cells that I want to link up next or after the cell could be linked shown automatically? Thanks

[aylinciftci]

Do you know why it might still give a "REF!" even though you also allowed access, when using the formula for the first time?

[topratedfreelancer]

Thank you and thank you very much for your description note

[sugarey]

I'm new to google sheets, can you demo (or someone tell me from reply) how to paste multiple cells from one csv file into a different csv file on google sheets. When I do it all the cells paste into 1 cell big cell.

[rouhag]

Very helpful! Is there any way to link to a cell/range that can survive the sorting function?

[shrirajdeshpande]

Not working for me though both files belongs to my drive location only and I am the only owner

[fbarolia]

Hi
Thank you very much, I followed the method you described in your video and my cell shows the link also but it does not show the value brought from the other cell of the sheet

[steveitmanager]

Can you shift and right copy to drag this formula along a row?

[Athith]

How can we import the color from two different sheets

[tongvang]

Dont think this works when you sort it, the link is attach to the initial cell but not the updated sorted cell. Is there a solution to this?

[Izaya_Orihara]

Does this still work if you rename the sheet?

[mowe]

Hey man this totally messed up my macro. It brought the macro set up on my sheet 1 into all my other sheets. 😢