linking excel worksheets

[john b]

hi hope im posting in the correct forum. :wave:

anyways here goes, how do you link two worksheets in excell so that all of the formulas in one are the same in the copy and so that when you enter any further data in worksheet on it will appear on the copy any help would be greatley apreciated as i need to do this for an as level modual for ict.

im using microsoft excel 2003 edition

[john b]

can any one please help cause i cant seem to figure it out, i can link single cells the way i want but not the whole page.

[john b]

hi everyone
i still have this problem and cant figure it out but i really need to get it done and my teacher dosent know how its done , i can only link single cells but i really need to link the entire worksheet, can any one please help

[Miz]

Open Excel and then, up at the top, click on Help then on Microsoft Excel Help. Go to the Answer Wizard tab and type link worksheets into the "What do you want to do?" field, click the Search button.

In the list at the bottom, click on "Overview of linked and embedded worksheets" and see the information displayed in the right-hand pane. That should get you started.