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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lexi" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> How do I take a cell in one worksheet and add it into the formula in a
> different worksheet in the same workbook?
>

That helped me out thanks!


Bernard Liengme wrote:
> 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
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Lexi" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > How do I take a cell in one worksheet and add it into the formula in a
> > different worksheet in the same workbook?
> >

That helped me out thanks!


Bernard Liengme wrote:
> 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
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Lexi" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > How do I take a cell in one worksheet and add it into the formula in a
> > different worksheet in the same workbook?
> >