Answer the question
In order to leave comments, you need to log in
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?
Answer the question
In order to leave comments, you need to log in
"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 questionAsk a Question
731 491 924 answers to any question