Excel formulars

[Matthew_weinberg]

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?

 

[Mike H]

Hi,

put this in E8 sheet 2

=Sheet1!B6


Mike

 

[JLatham]

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

 

[Mike H]

Good point, thanks for that

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