CODEWITHSUNDEEP
google-sheets
Felix Oje
Felix Oje

Reputation: 83

Google Sheets: Formulas over multiple sheets

Is it possible to grab the contents of a cell from one sheet and display them on another?

I have 4 sheets. And I want the cells of the third sheet to display the first column of the second sheet on the second column.

Upvotes: 3

Views: 6181

Answers (6)

deags
deags

Reputation: 478

Yes. For specific ranges you can use IMPORTRANGE.

Upvotes: 1

TheMaster
TheMaster

Reputation: 50501

Is it possible to grab the contents of a cell from one sheet and display them on another?

Yes. It's even possible to get entire columns of data.

In sheet 2 A1,

 =ARRAYFORMULA('Sheet1'!A:A)

The single quotes ' can be omitted, if the sheet name doesn't have a space . In other words, if you use Monthly Budget as a sheet name, then single quotes is mandatory.

Upvotes: 0

user6637260
user6637260

Reputation:

if you want to get range from another sheet just use:

Replace 'Sheet' and 'A2:C8' with title and range you want to refer 

={Sheet!A2:C8}

For multiple sheets

Replace ';' with ',' for horizontal view:

={Sheet!A2:C8;Sheet1!A2:C8;Sheet2!A2:C8}

Upvotes: 3

Bob Okafor
Bob Okafor

Reputation: 63

These are the annotations for cells in google sheets

Sheetname!A:1 For Relative Cells Sheetname!$A:1 For Absolute Columns Sheetname!A:$1 For Absolute Rows Sheetname!$A:$1 For Absolute Cells

Upvotes: 2

Patrick Odum
Patrick Odum

Reputation: 222

Add the sheetname exclamation point to your cell reference

e.g. sheet!A:1

Then drag from the first cell down to as many rows as you need.

Upvotes: 2

3pitt
3pitt

Reputation: 941

Google Sheets allows reference between sheets. the syntax is pretty simple. consider a single cell: =<sheetname>!A2 for example. From there, you can drag down with the bottom right corner, and your your column will now be a copy of an arbitrary column in , in this case A

Upvotes: 2

Related Questions