Excel formulars
 

Hi,
Can some one please help me?
Is there a formular that will take the info off cell b6 sheet 1 and put it
into cell e8 sheet 2?

Excel formulars
 

Hi,

put this in E8 sheet 2

=Sheet1!B6


Mike

"Matthew_weinberg" wrote:

Hi,
Can some one please help me?
Is there a formular that will take the info off cell b6 sheet 1 and put it
into cell e8 sheet 2?

Excel formulars
 

Do like Mike H said. If the sheet name that you're referencing has any
spaces in its name (as 'Sheet 1' instead of 'Sheet1') then enclose the sheet
name in the formula with single quote marks as:
='Sheet 1'!B6


"Matthew_weinberg" wrote:

Hi,
Can some one please help me?
Is there a formular that will take the info off cell b6 sheet 1 and put it
into cell e8 sheet 2?

Excel formulars
 

Good point, thanks for that

"JLatham" wrote:

Do like Mike H said. If the sheet name that you're referencing has any
spaces in its name (as 'Sheet 1' instead of 'Sheet1') then enclose the sheet
name in the formula with single quote marks as:
='Sheet 1'!B6


"Matthew_weinberg" wrote:

Hi,
Can some one please help me?
Is there a formular that will take the info off cell b6 sheet 1 and put it
into cell e8 sheet 2?