| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Formulars | Excel Worksheet Functions | |||
| Putting two formulars together in excel | Excel Discussion (Misc queries) | |||
| formulars | Excel Worksheet Functions | |||
| need help with formulars | Excel Discussion (Misc queries) | |||
| Formulars | Excel Worksheet Functions | |||
Linear Mode
