automatic save cell to different cell

[james]

I have two worksheet in my excel file. I would like to save data to specific
cell in worksheet 2 when I enter data in worksheet 1. Could anyone help?

[Gord Dibben]

james

In the cell on sheet2 enter this formula =sheet1!A1

Note the exclamation mark(!) must be entered.

When you change sheet1A1 then sheet2 cell will change also.

This process is called "linking".

For more, see Help on "linking".

Gord Dibben Excel MVP

On Wed, 5 Jan 2005 08:09:02 -0800, "james" <[email protected]>
wrote:

>I have two worksheet in my excel file. I would like to save data to specific
>cell in worksheet 2 when I enter data in worksheet 1. Could anyone help?