Google Spreadsheet referencing from one sheet to another

Question:

( by dollfacedx )

I want to import one single cell - NOT a range of cells

How do I link the value of one single cell from one spreadsheet to the next so that when I type a figure in the cell on one page of a spreadsheet, that same value is automatically added to the cell on the second page of the same spreadsheet?

Thank you.

Solution:


If you want to copy a value from one sheet to another, and have it update automatically, try the following formulas:

='sheet2 name'!A1

for a single cell.

Or

=arrayformula('sheet2 name'!A3:C4)

for a range of cells.

Or

=arrayformula('sheet2 name'!A3:C)

for whole columns.

Or

=arrayformula('sheet2 name'!A3:4)

for whole rows.

Put any one of the above formula (as per your requirement) to the first Sheet.


I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.

I also take up private and confidential projects:

http://igoogledrive.blogspot.com/p/paid-projects.html

If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here: http://igoogledrive.blogspot.com/2012/09/donate.html 

Thanks,

Kishan.

iGoogleDrive