worksheet content changes based on another worksheet?

  • Thread starter Thread starter cpliu
  • Start date Start date
C

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
 
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.
 
Back
Top