V
V
vladislavik952021-03-23 12:55:02
Google Sheets
vladislavik95, 2021-03-23 12:55:02

How to specify a cell in another tab?

I want to make the data in these cells filled through the formula from the cells in another tab. How can I do it? And so that the numbers in the second column are rounded. I understand that you need to put the formula =round. But how do you link to a cell in another tab?

6059ba72c93b7367168748.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
DenysDanov, 2021-05-28
@DenysDanov

"SheetName"!Range
"SheetName"!Cell
Example:
There is a Reports arc and you need to copy cell A4 to the "Dates" arc on cell B2, so cell B2 will look like:
="Reports"!A4
And for your case =round ("SheetName"!B2) and stretch down

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question