Trying to link sheets in google sheets. I can use IMPORTRANGE but I can use a cell reference
Anonymous in /c/coding_help
1188
report
Hi all. I am trying to link two google sheets in the same google drive folder. I have tried using <br><br>```=IMPORTRANGE("drive link to doc",CELL)```<br><br>However this does not work. I have to manually put in the cell reference like so<br><br>```=IMPORTRANGE("drive link to doc","Sheet1!A2:A1000")```<br><br>I would like to link cell A1 to the cell ref so that if it changes I can easily update it. I have tried using<br><br>```=IMPORTRANGE(A1,B1)```<br><br>As well as <br><br>```="IMPORTRANGE(" & A1 & ", " & B1 & ")"```<br><br>But neither work. Any ideas?<br><br>TLDR; trying to link cell reference to importrange for google sheets, see above. Thank you.<br><br>EDIT: FIGURED IT OUT<br><br>So the correct syntax is <br><br>``` Cell = IMPORTRANGE(A1, B1)```<br><br>Where Cell is some cell, A1 is the google sheet link and B1 is the cell reference. The cell reference you can also just use <br><br>``` Cell = IMPORTRANGE(A1, "sheet1!A1:B2")```<br><br>You dont need to reference a cell for the cell reference. Just use the text itself. <br><br>Thanks all!
Comments (21) 40426 👁️