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

  • Thread starter Thread starter Lexi
  • Start date Start date
L

Lexi

How do I take a cell in one worksheet and add it into the formula in a
different worksheet in the same workbook?
 
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
 
That helped me out thanks!


Bernard said:
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
Click to expand...
 
That helped me out thanks!


Bernard said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Worksheets 3
Can I use a worksheet name in a formula? 4
how do i copy the result of a formula into another worksheet as te 3
How to Auto Reference Worksheet Tab ID's in Formulas? 9
how do I use a cell from one worksheet in the equation of another 3
Source and Destination worksheet difference 5
names in different worksheets 2

Back
Top