Taking one value sheet 1 and apply to sheet 2

[join_the_band]

Hello all,
I have a workbook with 5 sheets. I do not know how to take the value from sheet 5 cell b26 and use that value to a formula to sheet 1 cell g19.

Can someone help me out?

[join_the_band]

She showed me how to do it.

Sorry

[Chip Pearson]

Try a formula like

=Sheet5!B26


"join_the_band"
<join_the_band.2926qb_1149728701.4689@excelforum-nospam.com>
wrote in message
news:join_the_band.2926qb_1149728701.4689@excelforum-nospam.com...
>
> Hello all,
> I have a workbook with 5 sheets. I do not know how to take the
> value
> from sheet 5 cell b26 and use that value to a formula to sheet
> 1 cell
> g19.
>
> Can someone help me out?
>
>
>
>
> --
> join_the_band
> ------------------------------------------------------------------------
> join_the_band's Profile:
> http://www.excelforum.com/member.php...o&userid=35211
> View this thread:
> http://www.excelforum.com/showthread...hreadid=549759
>