How do I take a cell in one worksheet and add it into the formula in a different worksheet in the sa

[Lexi]

How do I take a cell in one worksheet and add it into the formula in a
different worksheet in the same workbook?

 

[Bernard Liengme]

Do you mean something like =2*Sheet1!A1 ?
This returns twice the value of Sheet1's cell A1
You can type as shown or:
type =2*, open Sheet1 by clicking its tab and click the cell A1
either continue typing, or click the green check mark or use ENTER to finish
the formula

Not that is the sheet's name has a space in it, then it appears as 'January
data'! with single quotes around the name (not the explaination mark!)

Does this answer your question?
best wishes

 

[Lexi]

That helped me out thanks!

Do you mean something like =2*Sheet1!A1 ?
This returns twice the value of Sheet1's cell A1
You can type as shown or:
type =2*, open Sheet1 by clicking its tab and click the cell A1
either continue typing, or click the green check mark or use ENTER to finish
the formula

Not that is the sheet's name has a space in it, then it appears as 'January
data'! with single quotes around the name (not the explaination mark!)

Does this answer your question?
best wishes

 

[Lexi]

That helped me out thanks!

Do you mean something like =2*Sheet1!A1 ?
This returns twice the value of Sheet1's cell A1
You can type as shown or:
type =2*, open Sheet1 by clicking its tab and click the cell A1
either continue typing, or click the green check mark or use ENTER to finish
the formula

Not that is the sheet's name has a space in it, then it appears as 'January
data'! with single quotes around the name (not the explaination mark!)

Does this answer your question?
best wishes