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?