Linking Sheet with other sheets

[vazregan]

Hi guys, i am a fairly new user to Excel, and i work with a lot of excel sheets at work, and i am trying to get process a little easier and for that purpose, i need to be able to link cells from one sheet in a workbook to another sheet in the same workbook, can someone please tell me how to go about doing it? So essentially, when i enter for eg if i enter my name: Regan in one sheet it should automatically update my name in the next sheet (on the same work).

[sweep]

Hi,

You can do this by making the cell where you want the information to appear equal to the cell where you're entering it.

Eg,

You enter your name on Sheet 1 in cell A1

On sheet 2 in cell A1, type "=Sheet1!A1"

[oldchippy]

Put you name in A1 of Sheet1, go to Sheet2, click in A1, press =, click on Sheet1 tab, click cell A1.