I have a question about the formula. I just set up sheet 2 to match th
ings entered in sheet 1 but my formula is =Sheet1!A2 not =Sheet2!A2

"Harlan Grove" wrote:

"Otto Moehrbach" wrote...
Say your data in worksheet 1 starts in A2. In worksheet 2, cell A2, enter
an equal sign. Then select worksheet 1 and click on cell A2. Hit Enter.
In worksheet 2, select A2 and drag that formula down with the fill handle as
far as you need to. Repeat all this for column B. There are other ways if,
for some reason, you don't want the above.
....

Picky: inserting or deleting rows in either worksheet could alter
this. Row DELETION could be handled by making the Sheet2 formulas

Sheet2!A2: =INDEX(Sheet1!$A:$A,ROW())

Sheet2!B2: =INDEX(Sheet1!$B:$B,ROW())

And if column deletion could also be an issue,

Sheet2!A2: =INDEX(Sheet1!$1:$65536,ROW(),COLUMN())

would always refer to the corresponding cell in Sheet1.

Only event handlers could deal with row/column INSERTION in which case
new formulas for newly blank cells would be needed.