Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use formulars from another worksheet
Hi, am in college and am trying to use excel to create a worksheet that I can
use to do my homework and study. I want to input the formulas on sheet2 in excel, the formulars will also contain information on how to use them. I would like to be able to easily transfer the formulas and the information on how to use the formulas from sheet2 to sheet1, without using copy and past. Do I need to use a macro for each formula? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use formulars from another worksheet
You can reference other sheets in a workbook by using this formula:
=Sheet2!A1 Note that the '!' is very important. If you are referencing a different workbook, use this formula ='[OtherWorkbook.xls]Sheet2'!A1 "Excel101" wrote: Hi, am in college and am trying to use excel to create a worksheet that I can use to do my homework and study. I want to input the formulas on sheet2 in excel, the formulars will also contain information on how to use them. I would like to be able to easily transfer the formulas and the information on how to use the formulas from sheet2 to sheet1, without using copy and past. Do I need to use a macro for each formula? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use formulars from another worksheet
Just a small addition:
if your worksheet has a space in the name: ='my formulas'!A1 the ' are needed if there is a space in the name. Cheers Carlo On Dec 6, 10:39 am, Raza wrote: You can reference other sheets in a workbook by using this formula: =Sheet2!A1 Note that the '!' is very important. If you are referencing a different workbook, use this formula ='[OtherWorkbook.xls]Sheet2'!A1 "Excel101" wrote: Hi, am in college and am trying to use excel to create a worksheet that I can use to do my homework and study. I want to input the formulas on sheet2 in excel, the formulars will also contain information on how to use them. I would like to be able to easily transfer the formulas and the information on how to use the formulas from sheet2 to sheet1, without using copy and past. Do I need to use a macro for each formula?- Hide quoted text - - Show quoted text - |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use formulars from another worksheet
Thanks for the reply.
I was thinking of having several formulas on sheet2, then only transfer the formula that I need. Sometimes when I copy information in excel a pop up widow comes up on the right hand side will the information that i copied. I would like something like that but it would be permanent. Exp. If I have data from cell A1 to C3, would I be able to easily transfer all the information from those cell to sheet1? Thanks "Raza" wrote: You can reference other sheets in a workbook by using this formula: =Sheet2!A1 Note that the '!' is very important. If you are referencing a different workbook, use this formula ='[OtherWorkbook.xls]Sheet2'!A1 "Excel101" wrote: Hi, am in college and am trying to use excel to create a worksheet that I can use to do my homework and study. I want to input the formulas on sheet2 in excel, the formulars will also contain information on how to use them. I would like to be able to easily transfer the formulas and the information on how to use the formulas from sheet2 to sheet1, without using copy and past. Do I need to use a macro for each formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hidding formulars used in a worksheet | Excel Worksheet Functions | |||
formulars | Excel Worksheet Functions | |||
need help with formulars | Excel Discussion (Misc queries) | |||
Worksheet formulars | Excel Worksheet Functions | |||
Formulars | Excel Worksheet Functions |