Basic Query

[KiwiBrian]

Hypothetical scenario:-
I have a 5 column 2000 row spreadsheet and wish to manualy eliminate some
entries because they are superfluous or duplicates.
I create a new SS from just 2 columns to make it easier to work with..
I do my editing on the new SS.
Can I now "apply" those changes to the original SS?
Or am I breaking a basic rule and will now have "misaligned" records?
I hope my query is clear in spite of my poor description.

TIA
Brian Tozer

 

[Dick Kusleika]

Hypothetical scenario:-
I have a 5 column 2000 row spreadsheet and wish to manualy eliminate some
entries because they are superfluous or duplicates.
I create a new SS from just 2 columns to make it easier to work with..
I do my editing on the new SS.
Can I now "apply" those changes to the original SS?
Or am I breaking a basic rule and will now have "misaligned" records?

Yes, you have. You could recreate the first sheet based on what's in the
second, but it's more work that it's worth. If you want just two columns
while you're working, consider hiding the three columns you don't want to
see. If you delete any rows with those columns hidden, it will still delete
them.