Worksheets

[Guest]

I have a file that I have to fill out for one of our buyers and it has two
sheets to it. Some of the information that I enter on one worksheet can also
be entered onto the 2nd worksheet. What can I change so that when I enter
the info on one sheet, it automatically transfers to the 2nd sheet?

 

[natei6]

I have a file that I have to fill out for one of our buyers and it has
two
sheets to it. Some of the information that I enter on one worksheet
can also
be entered onto the 2nd worksheet. What can I change so that when I
enter
the info on one sheet, it automatically transfers to the 2nd sheet?

Try something like this assuming you are in sheet 2 and you want
something from sheet 1.

=Sheet1!B4

 

[prabhuraaman]

If you want the information to be entered in the second worksheet in
the same cell as in the first worksheet,
Select both the worksheets and type the value

If you want the value to change in the second worksheet as and when you
change the value in the first worksheet use the pastelink option in the
edit<pastespecial menu