Basic Query

  • Thread starter Thread starter KiwiBrian
  • Start date Start date
K

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
 
KiwiBrian said:
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?
Click to expand...

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