How do I use formulars from another worksheet

  • Thread starter Thread starter Excel101
  • Start date Start date
E

Excel101

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?
 
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
 
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

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 said:
Hi, am in college and am trying to use excel to create a worksheet that I can
use to do my homework and study.
Click to expand...
I want to input the formulas on sheet2 in excel, the formulars will also
contain information on how to use them.
Click to expand...
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.
Click to expand...
Do I need to use a macro for each formula?- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...
 
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 said:
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 said:
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?
Click to expand...
Click to expand...
 
Back
Top