Bruce,

If you a column (or columns without data , sorting will not include data to
the right of these.

Just a thought,
Don

--

"Bruccce" wrote in message
et...
I have a spreadsheet that I keep getting info from different rows on to
the
wrong rows. This has happened several times.
I first thought (and I really try to be very careful not to do this!) that
I
sorted some of the rows with out including all of the rows. I always try
to
click on the upper left hand square before doing any sort!

What can I do to prevent this data corruption, or make it so I can recover
my data?
I am thinking about a extra spreadsheet and anytime the data is changed in
a
row, that the whole row be copied to this spreadsheet. Would this work?
any
other ideas?

I have just lost about 9 days worth of calls (about 7 hours a day) due to
this corruption. I do have some backups, but I don't know when the data
got
corrupted.

HELP!
Thanks
Bruce