worksheet content changes based on another worksheet?

[cpliu]

Because my data is too long horizontally, I thought it would be easier
to read by moving some to a new worksheet. The data would be visible
without scrolling. I didn't copy and paste but used = to the cell of
the old worksheet.

This works fine if I don't change too much, but it won't work if I:
insert delete, rows, sort the data (= changed the order)

Then the new one does not update and messed up completely.

I think I may not use it the right way. What is best way to solve my
problem?

Thanks for the help,

liu

 

[Gary''s Student]

Make sure that BOTH spreadsheets are open when the source is being editted.
The new sheet will have a much easier time keeping track of the adjustments.

 

[Bob I]

Might I suggest using the "split" window view instead with a single
worksheet?