Thank you James! This is exactly what I needed!


"James Hamilton" wrote:

Assume you want to enter the data in cell A1 of sheet 1.

1. go to sheet 2 and in cell A1 enter, "=Sheet1!A1"
2. do the same in cell A1 of sheet 3
3. enter your data into cell A1 of sheet 1. It will appear in cell A1 of the
other two sheets.

James

"lucasjackson" wrote:

Here's what I want to do:
I have three sheets which share data/names/info.
I only want to type it in once.
For example: Sheet 1, cell A1 will have the same info as Sheet 2, cell B2,
and sheet 3, cell C3.
Is there a way to type it in once into Sheet 1, and have it copy
automatically into the other sheets?

Thanks in advance for helping.